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.
This is the 8th installment of my XML Workshop which aims at explaining the details of working with XML in TSQL.
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.
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.
This installment illustrates how to use PowerShell script to loop through the content of the file and connect to different servers.
If you're in the Charlotte, NC area, the user group is meeting on October 16, 2007
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.
A look at how one of our longtime members goes about hiring new DBAs.
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.
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.
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
Long time listener, first time caller. I have a problem that my usual bag...
How many table hints can I include in a query?
See possible answers