SQL Server 2005 – DML Usage on an untyped XML column
Learn how to use Data Manipulation Language, a set of statements used to store, retrieve, modify, and erase data from a database, for untyped XML columns.
2006-09-18
1,895 reads
Articles
Using and Monitoring SQL 2005 Query Notification
The aim of this article is to show you how to make full use of SQL 2005 query notification with ASP.NET 2.0. It tackles the implementation details largely from SQL Server's perspective and includes many DBA tips and tricks for troubleshooting query notification.
2006-09-15
2,087 reads
SQL Server Spotlight on Steve Schmidt
Steve Schmidt, the backup guy for SQL Server, spent a few minutes talking about his work on SQL Server and life. A look at another very interesting member of the SQL Server development team.
2006-09-14
3,283 reads
Clustering SSIS
By default, SSIS is not an easily cluster-aware product. In this video, Brian shows you how to cluster the service and make it highly available.
2006-09-14
1,754 reads
Time for Training
Keeping up with your professional development is tough. In the first part of his series, Andy Warren talked about the challenges of keeping current. This article takes a look at how you can effectively find time to grow your career.
2006-09-13
5,800 reads
Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Se
This article discusses: Extensibility in SQL Server 2005 Reporting Services, Creating and debugging custom report items, The ProgressTracker CRI sample.
2006-09-13
2,458 reads
Email Changes
We've changed the way we send email for the newsetters. Read about our new address and whitelisting.
2006-09-12
2,441 reads
Reporting v Editing
In response to his article on using Reporting Services to manage rights, Jonathan Spink takes a look at how Reporting Services can be positioned in your enterprise.
2006-09-12
5,221 reads
Speak Like a T-SQL Developer
In this video by Kathi Kellenberger, she starts beginners interested in T-SQL programming the teminology and some of the basiics of T-SQL. She also covers the what the various editions of SQL Server mean and the tools that you will use.
2006-09-12
3,036 reads
Identifying Unused Objects in a Database
Longtime author Leo Peysakhovich answers one of the most common questions seen in discussion areas around the world: how do you identify unused objects?
2006-09-11
26,575 reads
Blogs
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
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...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers