Toolbox - Where Did All My Space Go?
This is the first in a new series of blogs I am going to create talking about useful tools (mostly...
2017-07-14 (first published: 2017-07-03)
2,173 reads
Blog Posts
Capture Important Parameters of the SQL Server Replication
Whenever there is a business requirement to add a new article to an existing publication, you want to know how...
2017-07-13 (first published: 2017-07-03)
1,687 reads
My Evening With SQL Tool Service
Hello!
I’ve been writing a PowerShell Module that will handle deploying SQL Server Agent Jobs by using the Agent namespace in...
2017-07-13
232 reads
No, Binary Collations are not Case-Sensitive
Quite often people will use, or will recommend using, a binary Collation (one ending in “_BIN” or “_BIN2“) when wanting...
2017-07-13
2,127 reads
The Three A’s: Auditing
Authentication and Authorization, the first two of the three A’s of security, control who gets access to what. However, at...
2017-07-13 (first published: 2017-06-28)
1,621 reads
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
154 reads
I’m Speaking! Evansville Technology Group
SQL Server user group is a backbone of the SQL Server community. I currently help run the Louisville SQL Server...
2017-07-12
454 reads
I’m Speaking! Evansville Technology Group
SQL Server user group is a backbone of the SQL Server community. I currently help run the Louisville SQL Server...
2017-07-12
121 reads
LocalDB DSC Script
Hello!
So, there are many different product SKUs of SQL Server available, and generally when developing it’s probably best to use...
2017-07-12
289 reads
SSRS Report Deployment Made Easy – 700 times Faster
Back in October 2016, Microsoft started a new GitHub repository – ReportingServicesTools – an open source PowerShell module to manage SQL Server...
2017-07-12
3,930 reads
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers