XML Workshop VIII - Custom Types and Inheritance
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
A New (and Hopefully Better) Approach to Constants
A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.
The College Experience
We published an article about how one DBA goes about hiring new DBAs and in the discussion that followed there was something that caught my eye. There were a few comment talked about how college degrees don't necessarily mean anything.
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
Charlotte's SQL Server User Group
If you're in the Charlotte, NC area, the user group is meeting on October 16, 2007
The Pay Jump
Workers Rarely Jump Ship Over Pay Alone is an article that I saw awhile back and saved. It is 100% true and should be required reading by every C-level knucklehead and MBA student.
Who wants to be a SQL Server DBA?
A look at how one of our longtime members goes about hiring new DBAs.
Restore your SQL Server database using transaction logs
Most DBAs dread hearing that they need to restore a database to a point in time, especially if the database is a production database. However, knowing how to do this is of the utmost importance for a DBA's skill set. I'll walk you through the steps of how to restore a SQL Server database to a point in time to recover a data table.
Fun with Computers
The whole entertainment aspect of computing is growing tremendously and we're slowly seeing a convergence in our living rooms of computing capabilites along with entertainment. From rocker chairs with speakers to TiVo-type devices, the Nokia Internet Tablet, and XBOX 360s and Playstations that can enhance our movies.
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