Common table expressions and circular references
Finding circular references that are stopping your CTE from working.
What Counts for a DBA: Patience
Technical debt is frustrating but dealing with it requires patience. Louis Davidson explains why.
SQL Saturday #251 Paris, France
SQL Saturday is coming to Paris on September 14th 2013. Join us for a free day of SQL Server training and networking. This SQL Saturday will include a track on Business Intelligence, SQL Server, and something for beginners.
SQLServerCentral Webinar Series #26: Best Practices in Database Deployment Part 2
This Tuesday Grant Fritchey and David Simner will give you a step-by-step guide to how you can automate your database deployment Process using Red Gate Deployment Manager.
Test Your SQL Server Backups with PowerShell
The best way of checking SQL Server backups is to restore them and run DBCC CHECKDB on the restored database. To do this regularly means that you need to automate the task. Allen White shows how, with PowerShell.
Drive Space Monitoring Gets An Update
Monitoring drive space is something every DBA ought to be doing. Shaun Stuarts brings us a method that can easily be used to keep track of your SQL Server instance
Great IT Shops
Do you work in a great IT shop? Steve Jones talks about some of the things that make one and wonders if you feel you work at a great company.
The Database Administrator's Back-to-School Checklist
To meet the upcoming demands on IT systems database administrators (DBAs) need to prepare the database and its supporting infrastructure for increased resource demands. Being proactive now can pay big dividends by maintaining service level agreements (SLAs), avoiding outages and resource shortages, and ensuring a positive overall customer experience.
The Value of Your Time
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers