Limits vs Goals
It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us....
2017-03-27 (first published: 2017-03-14)
1,134 reads
Blog Posts
Monday Coffee 2017-03-27
Hey all, I’m back after attending SQL Saturday in Iceland. This week’s going to be busy!
I’ve said before that SQL...
2017-03-27
248 reads
Orlando Code Camp 2017
I’ll be attending and speaking at Orlando Code Camp on April 8th. Come by and say hello if you’re attending,...
2017-03-27
414 reads
Reading the January 2017 PASS Minutes
I’ve been catching up on stuff this week, including reading the January 2017 minutes. It was in-person meeting so a...
2017-03-27
378 reads
Reviewing the PASS 2017 Budget
I did a quick review of the 2017 PASS Budget. It’s not a page turner, but it has a lot...
2017-03-27
373 reads
sp_SrvPermissions & sp_DBPermissions V6.0 Finally!
It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well,...
2017-03-27
513 reads
SQL Saturday 619. Join me April 29, 2017 in Rochester, NY and learn to Paint with PowerShell!
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2017-03-27
315 reads
SQLBits 2017
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...
2017-03-27
309 reads
Test your Sqlserver backups on Linux with PowerShell and dbatools
I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts.
With SQL Server vNext...
2017-03-27
352 reads
Columnstore Indexes – part 100 (“Identity”)
Continuation from the previous 99 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
In Data Warehousing one will not be...
2017-03-25
797 reads
Blogs
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
When Your Microsoft Fabric Capacity Runs Out: Optimize, Scale Up, Scale Out, or Isolate?
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers