SQL Server Training in 2013–SQL Server Virtualisation and Consolidation
As we approach a new year many of you will be looking at your SQL Server Training needs for 2013....
2012-12-19
774 reads
Find Nth highest salary using RANKING functions
Suppose you want to find nth highest salary from a table,Then
you can use DENSE_RANK() function.Here i show some example that...
2012-12-19
50,541 reads
SSIS Precedence Constraint Tutorial
Recently we decided to create a series of videos for our SSIS Precedence Constraint Tutorial which is part of our...
2012-12-26 (first published: 2012-12-18)
9,214 reads
SQL Server 2008 Diagnostic Information Queries (Dec 2012)
Here is the December 2012 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2012-12-18
1,078 reads
Index Analysis: The Re-Return
A couple years back, I wrote a few blog posts about an indexing script that I use with clients from...
2012-12-25 (first published: 2012-12-18)
3,294 reads
Managing Schemas And Source Control For Databases
Visual Studio has a project type called “Database Project” that is used to manage a database schema and allows for...
2012-12-18
4,964 reads
SQL Saturday #143 - Washington, DC
Last week, I attended my very first SQL Saturday event in Washington, DC. Although I don't live anywhere near Washington,...
2012-12-18
562 reads
On the Sixth Day…
What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras? No animals have been hurt in the making of this post! This...
2012-12-18
9 reads
On the Sixth Day…
What better way to kick off the sixth day of pre-Christmas than with six slices of foie-gras? No animals have...
2012-12-24 (first published: 2012-12-18)
1,711 reads
SQL Server 2012 Cumulative Update 5
Microsoft has released SQL Server 2012 Cumulative Update 5, which is Build 11.0.2395. I count 28 fixes in the public...
2012-12-18
1,846 reads
Blogs
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....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
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?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers