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,406 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,795 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
This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.
2012-02-09
6,860 reads
2012-02-09 (first published: 2010-09-15)
10,192 reads
Come see Brad McGehee, Grant Fritchey, Steve Jones, and more SQL Server speakers at the SQL Server Connections conference in Las Vegas this spring. Get away from the cold on Mar 26, 2011 and learn about the new version of SQL Server.
2012-02-09 (first published: 2012-01-25)
4,069 reads
SQL Server 2008 R2 Integration Services offer a wide range of pre-built components, which deliver generic functionality commonly required when performing extraction, transformation, and loading tasks. While most of them are fairly straightforward to deploy in their basic form, typically there are refinements or caveats that should be taken into account as part of their implementation. This principle becomes quite evident when considering use cases of Sort transformation, which is the subject of this article.
2012-02-09
2,339 reads
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
I’m doing a small series on indexing basics for SQL Server, and on May...
Comments posted to this topic are about the item There's Too Much to Learn
Comments posted to this topic are about the item How to Calculate Distance Between...
Comments posted to this topic are about the item SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers