SQL Nexus Might Just Save Your Bacon
The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it...
2015-03-10
1,539 reads
The year is 2015, and I’m still surprised by how many people have never heard of SQL Nexus; although it...
2015-03-10
1,539 reads
UPDATED: Don't just take my word. Read the feedback from others.
SQL Cruise Caribbean 2015: More Than A Cruise With Classes....
2015-02-24
1,105 reads
It’s been almost five months since I posted my last article, and so much has changed since then. I have...
2015-02-11 (first published: 2015-02-03)
6,564 reads
I promised that I would post the slide decks for my presentations, and now I have finally followed through on...
2015-02-02
677 reads
In some of my previous posts, I have talked about how to create Columnstore indexes. Now I’d like to discuss...
2014-08-21
2,002 reads
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,094 reads
As I’ve discussed in some of my previous posts, there are quite a few data types that cannot be part...
2014-07-08
753 reads
In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...
2014-06-03
2,018 reads
SQL Server 2012 introduced non-clustered columnstore indexes, and SQL Server 2014 gave us clustered columnstore indexes. Both share the same...
2014-05-20
1,788 reads
First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...
2014-04-29
5,257 reads
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
I am very excited and lucky to be speaking once again at SQLBits along...
Hi everyone, I have a XML file in which data looks like this: <ArrayOfHomeModel...
Hi, I noticed that one of the database information is missing in sys.master_files catalog...
I'm running an index maintenance job on 1 of my large database as the...