Columnstore Indexes – part 103 (“Partitioning 2016 vs Partitioning 2014”)
Continuation from the previous 94 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have been wanting to write on...
2017-04-05
437 reads
Connecting a powershell session to a container
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
174 reads
Connecting a powershell session to a container
One of the questions that I was asked at SQL Saturday Iceland was “how can I view the filesystem within...
2017-04-05
471 reads
Getting SQLServers Last Known Good DBCC Checkdb with PowerShell and dbatools
As good SQL Server DBA’s we want to ensure that our databases are regularly checked for consistency by running DBCC...
2017-04-05
653 reads
ADO Connection Resiliency
It’s not easy to keep up with tech, here’s an update I missed – you can add params to the connection...
2017-04-05
670 reads
DevOps at VSLive–Austin
You can see me in May at VS Live in Austin, where I and many others will be talking DevOps....
2017-04-04
533 reads
IT Security Audit & Compliance Webinar Today (April 4) at 1 PM EDT
I’m speaking as part of a small panel for IT GRC Forum on keeping up your data security program in the...
2017-04-04
312 reads
I’m going to make you love backups
On April 12, I'm going to show you about two dozen ways to make your backups better, easier, faster, and...
2017-04-04
356 reads
Alerts From Azure Automation
In a previous post, I showed how to set up statistics maintenance for your Azure databases using Azure Automation. However,...
2017-04-04
638 reads
How I Became A…SQL Server Data Professional
Last night I saw a tweet from Matt Gordon (b|t); the topic caught my eye – “How I Became A…SQL Server...
2017-04-04
404 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers