Using TOP To Rank Columns In a Table
This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.
2011-10-25
6,564 reads
Articles
Using PowerShell for SQL Server Transaction Log Backups
How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.
2011-10-25
2,854 reads
Update multiple servers in a single bound
Learn how you can update multiple servers in a single bound with this technique from Kimberly Killian.
2011-10-24
3,956 reads
SQL in the City - LA
Come to SQL in the City, Friday Oct 28, in Los Angeles and meet Grant Fritchey, Brad McGehee and Steve Jones among others. A day of free training for SQL Server professionals.
2011-10-24 (first published: 2011-10-21)
2,347 reads
SQL# (SQLsharp): A Review
Only the brave, and foolhardy, write production CLR routines if you can get the functionality already-written and tested. Whether you’re a DBA or developer, there are plenty of times when a CLR routine will save a lot of time, and occasionally provide new functionality.
2011-10-24
4,490 reads
Diagnosing and Resolving Spinlock Contention on SQL Server
This paper describes how to identify and resolve spinlock contention issues observed when running SQL Server 2008 applications on high concurrency systems with certain workloads.
2011-10-21
2,992 reads
Extract multiple files with a MultiFlatFileConnection data flow task
A data flow task generated by the SSIS Import and Export Wizard can be configured to extract data from multiple files by changing the default connection manager to a MultiFlatFileConnection.
2011-10-20
4,917 reads
Raw Materials - Og, Sumerian DBA
A tale from the days when civilization was young and everything was harder than it is now.
2011-10-20 (first published: 2009-12-30)
10,731 reads
Auditing DDL Changes in SQL Server databases
Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the changes being made to a database and put those into Source Control, in order to track what changed and when. You can even get an email alert when it happens. With suitable scripting, you can even do it if you don't have direct access to the live database. Grant shows how easy this is with SQL Compare.
2011-10-20
2,823 reads
PASS Data Architecture Virtual Chapter presents Characteristics of a Great Relational Database
On Thursday October 20th ,MVP Louis Davidson will discuss the why normalized databases are the most important part of query tuning
2011-10-20
1,698 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers