Extended Properties Introduction
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
22,872 reads
Part one of a four part series intent on demystifying and making more accessible SQL Server extended properties
2013-09-27 (first published: 2011-03-17)
22,872 reads
Need to understand new data? This article explains why - and how you can profile it efficiently
2013-02-25
24,979 reads
Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.
2011-06-20
40,635 reads
To finish this short series on extended properties a look at documenting sets of database objects
2011-04-05
8,593 reads
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
11,948 reads
In this second article of a short series we look at using the Extended Properties which you have added to a database
2011-03-22
12,001 reads
When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?
2010-12-17 (first published: 2010-02-24)
17,065 reads
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
2010-01-25
5,617 reads
This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page
2009-09-16
9,241 reads
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
2009-09-09
40,728 reads
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
In this post, I will guide you on how to deploy a dockerized simple...
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
hi, i changed my mysql based linked server's timeout to N'600' instead of N'0'...
Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File...
hi a few days ago i narrowed down the cause of a new problem...
At what levels can we set the collation in SQL Server 2022?
See possible answers