XML-XSL Transformations in SQL Server
With the release of Master Data Services (MDS) for SQL Server 2008R2, it is now possible to perform XML transformations on the database server.
2012-01-04
7,771 reads
Articles
When to Break Down Complex Queries
Microsoft SQL Server is able to create very efficient query plans in most cases. However, there are certain query patterns that can cause problems for the query optimizer; this article describes four of these patterns.
2012-01-04
5,357 reads
Managing Transaction Logs
A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.
2012-01-03 (first published: 2008-10-31)
73,211 reads
2012-01-03 (first published: 2010-06-16)
9,172 reads
The XML Methods in SQL Server
The XML Data type has definite uses, but the way of interrogating, retrieving, and manipulating the values of properties and attributes within XML have been so foreign to the SQL language as to be somewhat of a barrier to their use. Fortunately, Robert Sheldon has once more managed to make the subject accessible to those of us who just need to get the job done.
2012-01-03
3,706 reads
Day Zero with PowerShell
Learn how to get setup with PowerShell and SQLPSX from MVP Aaron Nelson, one of the experts teaching us how to use Powershell for SQL Server.
2012-01-02 (first published: 2011-05-10)
15,839 reads
SQL Server in Luxembourg
The SQL Server Luxembourg User Group will be holding its first major event of 2012 on Tuesday 17th January, starting at 4:30pm. The venue will be Microsoft's offices at Cloche d'Or.
2012-01-02
343 reads
Querying SQL Server Agent Job Information
Is there an easy/automated way to get information on SQL Server Agent jobs instead of connecting to each server and manually getting the information through the SSMS GUI?
2012-01-02
3,521 reads
A Simple way of Automating Scripts
Deploying changes to your environments can be challenging, especially when you have multiple script files. Sadequl Hussain brings us a technique that works well and handles mutliple files.
2011-12-30 (first published: 2009-07-30)
51,385 reads
SQL Saturday #104 - Colorado Springs
Start your 2012 off right with a free day of training in Colorado Springs. Bring the kids as well, as the venue is very family friendly.
2011-12-30 (first published: 2011-12-06)
1,113 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers