The effects of an SSD on SQL Server Performance
I. Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me. Being a...
2012-07-29
5,685 reads
Blog Posts
Learning solid SQL Server and Business Intelligence skills through online training
I have just signed up for a one year standard subscription of Pluralsight Hardcore Developer Training. I’m focusing on SQL...
2012-07-28
1,648 reads
reconfigure vs reconfigure with override
You can change server properties of SQL Server using sp_confgure and to "save" it you need to use reconfigure. In...
2012-07-28
2,318 reads
SQL Saturday #150 & TechDay in Baton Rouge–Sharepoint
This year’s SQLSaturday in Baton Rouge includes a Sharepoint track with 2 local speakers(Cody Gros & Eric Trivette), MCM Tom Resing...
2012-07-28
972 reads
SQL Server 2008 R2 Service Pack 2
Microsoft has released SQL Server 2008 R2 Service Pack 2, which is Build 10.50.4000. It includes the fixes up through...
2012-07-28
2,340 reads
transparent data encryption steps
In this blog post I show steps that are needed to enable Transparent Data Encyption on a SQL Server 2012...
2012-07-28
1,580 reads
As one door closes another one opens
Normally I try and keep the things that happen at work separate from my blog, however it’s been an interesting...
2012-07-27 (first published: 2012-07-23)
2,520 reads
Color Expressions in SSAS Calculations
Color expressions in SSAS allow you to build an MDX expression to control the color of text displayed in a...
2012-07-27
1,673 reads
Different techniques to identify blocking in SQL Server
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...
2012-07-27
1,587 reads
How To Prevent SELECT * The Evil Way
SELECT * FROM…when administrators see that from developer code, we generally tend to cringe. Why? In a nutshell, it’s terrible on...
2012-07-27
1,887 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers