Tag Archives: sql server

Compatibility Level Confidence

Posted on September 21, 2020 by way0utwest

SQL Server databases have had a compatibility level in them for a long time. This is a number that essentially corresponds to a version. We had 70 for version 7.0, and then we went to 80 for SQL Server 2000, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Compatibility Level Confidence

Digging Into Internals

Posted on July 18, 2020 by way0utwest

Hugo Kornelis is a fellow Data Platform MVP and friend. He runs SQL Server Fast, and we recently put up an interesting page with this title: Debugging with debugger: investigating SQL Server’s internal structures. That’s a great title, and it … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Digging Into Internals

Adding Analysis Services (SSAS) to your SQL Server instance–#SQLNewBlogger

Posted on May 13, 2020 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is a fairly simple task, but recently I needed to test something in SSAS. I hadn’t installed this … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Adding Analysis Services (SSAS) to your SQL Server instance–#SQLNewBlogger

Encryption Libraries

Posted on April 7, 2020 by way0utwest

One of the ways we work to implement better security is through the use of encryption. I remember the early days of PGP, VPNs adding end to end encryption, IPSec becoming available, and more. I was excited to see column … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Encryption Libraries