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.
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.
Don’t Economize on Processors for Database Servers
In this guest editorial, Glenn Berry argues that, when designing your servers, you need to budget for processing power as your primary concern.
The Cost of Architecture
What's the cost of those architectural decisions that you make? It can be substantial if they aren't good ones, but is that a problem? Steve Jones talks a little about the implications
Update multiple servers in a single bound
Learn how you can update multiple servers in a single bound with this technique from Kimberly Killian.
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.
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.
Stairway to T-SQL DML Level 2: History of Structured Query Language (SQL)
Let’s step back in time and discuss the history of Structured Query Language, or what most SQL Server professionals just shorten to SQL. Fasten your seatbelts, crank up the time machine and travel back in time to follow the history of SQL and Microsoft SQL Server from its early years to where they are today.
Which Versions of SQL Server Do You Have?
This week Steve Jones asks about the versions of SQL Server that you have to support in your daily job. Answer this week's poll and let us know the width and breadth of support that you are responsible for maintaining.
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.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers