On Thursday February 16th at 12PM noon Central, Steve Simon will discuss “No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
2012-02-16
1,409 reads
The arrival of the (MAX) data types in SQL Server 2005 were one of the most popular feature for the database developer. At the time, there was a lot of discussion as to whether this freedom from having to specify string length came at a cost. Rob attempts to give a final answer as to any down-side.
2012-02-15
8,459 reads
This document shows how to install a Microsoft SQL Server 2008 R2 Reporting Services instance.
2012-02-14
24,924 reads
We asked Buck Woody to come up with his favourite 'Cloud' Howlers. After 'Howler' monkeys, we are faced with Howler letters. Buck dreams of sending Howler letters to the folks who dreamed up the marketing hype around 'cloud' services, who misunderstand services, who don't prepares applications for distributed environments and so on.
2012-02-14
2,677 reads
If you will be in London on Mar 29th, come to the official UK launch of SQL Server 2012 at SQL Bits X. Saturday is sold out, so if you registered and cannot come, please cancel. There are still a few spots for Thur and Fri.
2012-02-14 (first published: 2012-01-20)
3,219 reads
A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.
2012-02-13
4,410 reads
Learn how to create a SQL Server 2012 Active/Active cluster in Hyper-V using an iSCSI SAN
2012-02-13
7,991 reads
There are around seventy SQL Server instance settings, and a DBA needs to be aware of the effect that many of them have. Brad McGehee explains them in enough detail to help with most common configuration problems, and suggests some best practices.
2012-02-13
4,300 reads
At the last PASS summit, we cornered SQL Server MVP Glenn Berry, and found out his views on the impact of virtualization, solid state disks and SAN administrators on the life of a DBA, and what led him to write a book all about SQL Server Hardware.
2012-02-10
1,801 reads
The relational model was devised long before computer hardware was able to deliver an RDBMS that could deliver a fully normalized database with no performance deficit. Now, with reliable SSDs falling in price, we can reap the benefits, instead of getting distracted by NOSQL with its doubtful compromise of 'eventual consistency'.
2012-02-10
3,356 reads
Next up in my series talking about The Burrito Bot is diving into the...
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...
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