On the Eighth Day…
Today’s post is merely an illusion. The illusion being that we have finally stopped talking about the msdb database. I’ll explain about that later in this post. This should...
2012-12-20
4 reads
Blog Posts
PASS SQLRally Nordic 2012 videos online
All the videos for the sessions at PASS SQLRally Nordic 2012 are available for free. Lot’s of great BI info. Check...
2012-12-20
892 reads
Using XQuery to remove duplicate values or duplicate nodes from an xml instance
Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this...
2012-12-20 (first published: 2012-12-13)
19,511 reads
Active Directory Group Membership and Powershell
I’ve done my fair share of work with Active Directory over the years and LDAP has helped immensely, it did...
2012-12-19
833 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,525 reads
On the Seventh Day…
So far this series has been a bit of fun. We have discussed a fair amount of useful things to...
2012-12-19
1,430 reads
On the Seventh Day…
So far this series has been a bit of fun. We have discussed a fair amount of useful things to date. And here we are only on the seventh...
2012-12-19
5 reads
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
767 reads
Where is my backup?
We recently added responsibility for ~80 more servers to our team. This means that my team-mates and I are working...
2012-12-19 (first published: 2012-12-12)
2,033 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,949 reads
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers