Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many editions – requires somebody to feed and care for it. You're the "Microsoft Guy" (or Gal), so whether you wanted to be or not, you were elected. This series of articles is all about making you more effective with SQL Server as an administrator, not a programmer.
2009-06-25
7,556 reads
Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change
2009-06-24
3,907 reads
We look at performing the same task for the sys.dm_db_index_operational_stats Dynamic Management Function (or DMF.) The process is identical, the code is however quite different due to the structural differences between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
2009-06-24
2,265 reads
Yan Pan demonstrates how to set up Change Tracking on a table in the AdventureWorks2008 database and how to query the changed data.
2009-06-23
3,681 reads
Learn to take advantage of Hyper-V and Windows 2008 in order to achieve fault-tolerant and highly available SQL Server virtual machines.
2009-06-23
2,604 reads
If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing.
2009-06-22
3,641 reads
I tend to do a great deal of meta-data (or is it metadata) mining from the system compatibility views and system catalog views in order to build dynamic ad-hoc T/SQL code to use for various administrative processes.
2009-06-22
3,158 reads
This document describes the indexed views capability of SQL Server 2005 and SQL Server 2008, including the new support for partition-aligned views added to SQL Server 2008. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
2009-06-19
4,111 reads
When an enterprise first encounters master data management, it often doesn’t have a clear understanding of how MDM will affect the architecture of its business transaction systems or business intelligence systems. This article describes master data patterns in legacy system architectures, a general MDM architecture and some ways the new MDM layer affects the master data patterns in the legacy layers.
2009-06-19
2,401 reads
Learn to enable the FILESTREAM feature in SQL Server 2008 and configure your database to support it.
2009-06-18
2,817 reads
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
If you’ve been watching AI roll through the data community and thinking, “this seems...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
Comments posted to this topic are about the item Concurrency and Baseline Control: Level...
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers