Ask the Unicorn: Why is it Important to Know Tables in Filegroups?
Earlier this week, I wrote a quick blog post on a throw-away script I had written. The blog post was DETERMINING...
2013-02-01
623 reads
Blog Posts
Database Lifecycle Management for Azure SQL Database
DLM 1.0 Released Today When “SQL Azure” first became available a couple of years ago, I played with it, created...
2013-02-01
1,930 reads
FLOAT datatype casting issue
Do you use the FLOAT datatype? If so you had better read this……
Today I came across an issue somebody posted...
2013-02-01
5,134 reads
Reblog: January 25 to January 31
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-01
915 reads
SQL Intersection 2013 – Las Vegas in April
It’s not too hot, it can be fun, and after a full day of SQL Server learning, there are lots...
2013-02-01
1,231 reads
SQL Server 2012 Diagnostic Information Queries (Feb 2013)
Here is the February 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-02-01
1,001 reads
SSIS 6 Million Rows in 60 Seconds using standard laptop
SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could...
2013-02-01 (first published: 2013-01-28)
5,143 reads
SSRS 101 – Prerequisites
Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things...
2013-02-01 (first published: 2013-01-23)
4,267 reads
AD FS Token Based Authentication In Code
I’m writing this post more as documentation for myself as I know I will be repeating this process quite a...
2013-01-31
423 reads
Day 24 of 31 Days of Disaster Recovery: Handling Corruption in a Clustered Index
Welcome to day 24 of my 31 Days of Disaster Recovery series. Previously, I’ve talked about several different forms of...
2013-01-31
1,844 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Local Agents
Comments posted to this topic are about the item Local Agents
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers