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
788 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,015 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
11 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
191 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,173 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
344 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
392 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
219 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
550 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
"Click" your SQL Server into an MCP agent, with RBAC and full security
Hi guys and gals, I've created a system that automatically allows you to "generate"...
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers