Awesome SQL Server Feature
There are a lot of cool features in SQL Server that ROCK! It is really hard to pick just one with so many cool features that can make life...
2016-04-13
9 reads
Awesome SQL Server Feature
The second Tuesday of April 2016 is now upon us and you know what that means. Well, I hope you know...
2016-04-13
792 reads
Cardinality Estimator - Part 2- Out of Date Statistics
Continuing from our series on Cardinality Estimator 2014, Let us look at the first difference between 2 CE models. The...
2016-04-21 (first published: 2016-04-12)
2,016 reads
Build database schema snapshot functionality into your .NET application
If you wish to build your own .NET application that allows the user to take database schema snapshots on demand or schedule them to be taken at certain times,...
2016-04-12
14 reads
Build database schema snapshot functionality into your .NET application
If you wish to build your own .NET application that allows the user to take database schema snapshots on demand...
2016-04-12
199 reads
Partition Switching #TSQL2SDAY #77
The ALTER TABLE..SWITCH command allows you to almost instantly move large amounts of data from one table to another. It does...
2016-04-20 (first published: 2016-04-12)
4,179 reads
SSRS Report Won’t Render in VS Preview
I love getting get a laptop, but getting all the software reinstalled and making sure everything works can be trying....
2016-04-12
345 reads
T-SQL Tuesday #77–My Favorite Feature
This month is an interesting, but tough topic. The blog party is hosted by Jens Vestergaard, and his invitation is...
2016-04-12
743 reads
Speaking at SQL Saturday #526 in Rochester on May 14, 2016
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-12
398 reads
SQL Server 2016 features: Live query statistics
Ever wanted to look at a query’s actual execution plan (execution plan with runtime information) without waiting for the query...
2016-04-12
223 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers