Contained Databases in SQL Server 2012
One of the problems with databases in SQL Server is the dependency of the database on various parts of the...
2012-03-29
2,016 reads
Importing data from Excel – using INSERT statements
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However,...
2012-03-29
3,331 reads
Error 18456 a little more friendly in 2012
While preparing a demo for a presentation, I generated a 18456 error in the SQL instance by selecting a non-existent...
2012-03-29
1,180 reads
Why I am excited about SQL Server 2012 (Part 2)
Earlier this month I published a blog entry on this same subject. In honor of the local Minneapolis launch event,...
2012-03-28
704 reads
I am looking for change
I am looking for a change. Yes, a change. This is the beginning of that quest. This blog will be...
2012-03-28
844 reads
Microsoft Failover cluster 2008 : Moving MSDTC to new SAN disk
We have four node cluster on Windows 2008 where the MSDTC disk hosted on a SAN array. Now we have...
2012-03-28
5,962 reads
SQL Server 2008 Diagnostic Information Queries (April 2012)
Since it is nearly April, I will go ahead and jump the gun again and post an updated version of...
2012-03-28
1,091 reads
Stress Thoughts-Part 3
It’s not fair. I hear it a couple times a day. Sometimes they are right, sometimes not, but it’s how...
2012-03-28
691 reads
TinyInt problem in SSAS
If you have a source table that has a Tinyint primary key column defined as IDENTITY and you create a...
2012-03-28
1,625 reads
Presenting at SQL Saturday #111
On Saturday, April 14, 2012, I’ll be presenting “Table Vars and Temp Tables – What you NEED to know!” at SQL...
2012-03-28
721 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Trigger isn't working
Hi, I have a trigger, that works fine elsewhere but is not working at...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers