Have you ever wanted to compute age, but the results from the DATEDIFF function seemed to be wrong some of the time? This tip covers why the DATEDIFF function does not always reliably compute age.
2012-05-23
4,752 reads
This article describe the problems about the migration of the databases and logins and the new feature contained databases
2012-05-22
10,873 reads
Join us on May 22, 4:00GMT to learn how to include verification as a part of your backup and recovery strategy with Grant Fritchey.
2012-05-22 (first published: 2012-05-08)
5,945 reads
Before creating a data application in Windows Azure, it is important to make choices based on the type of data you have, as well as the security and the business requirements. There are a wide range of options, because Windows Azure has intrinsic data storage, completely separate from SQL Azure, that is highly available and replicated. Your data requirements are likely to dictate the type of data storage options you choose.
2012-05-22
2,650 reads
Instant file initialization also has its advantages when you restore a SQLServer database. This article will show you why.
2012-05-21
4,640 reads
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned the SQL Server 2012 certification program, making is more difficult, costly, and time-consuming to attain.
2012-05-21
797 reads
Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.
2012-05-21
4,173 reads
This May brings SQL Server experts to your locality; full day seminars in Edinburgh, Manchester, Birmingham, Bristol and London. Overview sessions from Microsoft in the morning, Deep Dive sessions in the afternoon from SQL Server MVP's and evening community events.
2012-05-21 (first published: 2012-05-10)
4,173 reads
2012-05-18
77 reads
This article will show you one way to quickly restore SQL Server replication with huge tables.
2012-05-18
7,762 reads
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers