SQL Server Permissions – Database Roles
EZ PZ Permission Squeezee
Given the critical level of importance related to permissions, one may think it is a concept that...
2017-03-02
1,453 reads
Blog Posts
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
20 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
46 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
36 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
420 reads
SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the IgnoreWhitespace, IgnoreComments, IgnoreKeywordCasing and IgnoreSemiColonsBetweenStatements flags affected the comparison....
2017-03-02
13 reads
Step By Step Logshipping configuration
Log shipping provides a means to maintain a secondary server on an automated basisusing a chain of transaction log backups. This chapter explains the basic confi guration oflog shipping...
2017-03-02
16 reads
Step By Step Logshipping configuration
Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups....
2017-03-02
21,683 reads
Tempdb settings in SQL Server 2016
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
415 reads
The Empirical Rule
I am resuming technical blogging after a gap of nearly a month. I will continue to blog my re learning...
2017-03-02 (first published: 2017-02-27)
2,534 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
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...
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