Querying the Plan Cache
I love working with indexes, and I need to know what’s using them to work on them intelligently. Most of...
2015-12-08 (first published: 2015-12-01)
2,017 reads
The Discomfort Zone
Over the Thanksgiving holiday, I read a book entitled The Phoenix Project. This book has been in my Kindle library...
2015-12-04 (first published: 2015-12-01)
1,532 reads
Summon Blue Screens of Death (for testing purposes only, of course)
Today I had a need to manually trigger and sustain a Blue Screen of Death (BSOD) inside a Windows Server...
2015-11-30
840 reads
Monday Morning SQL Break – November 30, 2015
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2015-11-30
840 reads
You should always have an “I got hit by a bus” backup plan
You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens...
2015-12-07 (first published: 2015-11-30)
2,454 reads
Row-Level Security part 2 – Controlling Write Access
My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible...
2015-12-03 (first published: 2015-11-29)
2,825 reads
Columnstore Indexes – part 73 (“Big Delta-Stores with Nonclustered Columnstore”)
Continuation from the previous 72 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Since the very first version of SQL...
2015-11-28
985 reads
Python Command Line Calls
There was a time I worked in a company any we lived in the command line. This was in the...
2015-11-27
1,115 reads
Find duplicate indexes in SSDT
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...
Duplicate indexes, one of the most pointless things you can do to a table that...
2015-11-27
987 reads
Find duplicate indexes in SSDT
Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5… Duplicate indexes, one of the most pointless things you can do to a table that just adds pure overhead. No one likes them...
2015-11-27
7 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
Alamat BCA KCP Pasar Minggu Telp:0821-8200-233
Telp/WA 62 821-8200-233 Jl. Raya Pasar Minggu No.6, RT.6/RW.8, Kalibata, Kec. Pancoran, Kota Jakarta...
Alamat BCA KCP Pejaten Telp:0821-8200-203
Telp/WA 62 821-8200-203 Ruko, Jl. Pejaten Mas Raya Jl. Raya Pasar Minggu No.Km.20 No....
Alamat BCA KCP Tebet Timur Telp:0821-8200-174
Telp/WA 62 821-8200-174 Jl. Tebet Timur Dalam Raya Blok GG No. 97, RT.3/RW.6, Tebet...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers