SQL Server 2014: Partition Improvements
SQL Server 2014 has enhancements to two common database maintenance operations:Partition Switching and Online Index Rebuild. This will greatly increase...
2013-09-26
1,221 reads
Blog Posts
Understanding Microsoft Self-Service BI Recording and Q&A
I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on September 26, 2013. If...
2013-09-26
1,354 reads
Webcast Follow-Up: Recognizing the Parallel Data Warehouse (PDW) Workload
Last Monday, I presented a session for Pragmatic WorksTraining on the T’s on the Microsoft’s Parallel Data Warehouse. In the session,...
2013-09-26
1,582 reads
Which personal traits should a #SQLPASS Director have?
A lot has been said about what each candidate would like to do and their track record of delivering in...
2013-09-26
1,089 reads
AdventureWorks2012 Bug on Azure
While I have production databases in Azure, I can’t exactly experiment with them at will. Further, while they mostly have...
2013-09-25
1,315 reads
Houston Tech Fest 2013
I am traveling (driving) with the family to Houston to present on SSIS 2012 at Houston Tech Fest 2013 at...
2013-09-25
605 reads
I’m Voting for Allen Kinsel
As you can see from the title of this post, I’ve decided on one of the three votes I’ll be...
2013-09-25
756 reads
It’s Election Season
It’s that time of the year again – time to make your voice heard as a PASS member. The PASS board...
2013-09-25
881 reads
Data Warehouse vs Master Data Managment
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a...
2013-09-24
1,445 reads
DBA Myths: You can’t use an alias in a DELETE statement
Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course,...
2013-09-24
878 reads
Blogs
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,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
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