SQL Filegroup/File Proportional Fill Algorithm
[read this post on Mr. Fox SQL blog] I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup...
2016-02-24
9 reads
Blog Posts
TSQL Tuesday #75 Round Up Redux
Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me...
2016-02-24
11 reads
TSQL Tuesday #75 Round Up Redux
Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me...
2016-02-24
19 reads
TSQL Tuesday #75 Round Up Redux
Okay so I already posted a round up post for this month. You can see it here. Tonight one of...
2016-02-24
431 reads
Webinar – SQL Server BI Best Practices
I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.
The title is SQL Server BI Best Practices and its...
2016-02-24
693 reads
Why Is The Server Slow?
This is blog post #2 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel.
If you haven’t been working in SQL Server for very...
2016-02-24 (first published: 2016-02-22)
2,843 reads
Columnstore Indexes – part 77 (“SSIS 2016 & Columnstore”)
Continuation from the previous 76 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I have written previously about SQL Server...
2016-02-23
690 reads
Monitoring wait stats
This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...
2016-02-23
172 reads
SQL Saturday Headshots
This past weekend was SQL Saturday #478 – Albuquerque, and I was happy to have the chance to attend again. I...
2016-02-23
746 reads
Take caution when altering a column using TSQL
When developing in SQL Server you are eventually going to have to modify a column or two (at least). And...
2016-02-23 (first published: 2016-02-17)
3,965 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