What is SSDT all about aka Why should I bother?
I often get asked the questions “What is SSDT” and I have wanted to have a single reference as to what it is as it is actually pretty big....
2016-01-05
2 reads
Ed Elliott's Sql Developer Blog
SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
1,212 reads
SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
205 reads
SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and...
2015-12-30
217 reads
SSDT Migrating Data Without Losing It
You sometimes want to do things like split a table into two or move a column into another table and when you use SSDT or the compare / merge...
2015-12-30
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
737 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
35 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
38 reads
T-SQL Clippy
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a lot of boiler plate stuff and offers re-writes for...
2015-12-10
3 reads
Automatically re-write non-sargable isnulls into sargable code in SSDT
"where ISNULL(column, 'DontMatch') = 'Match'" - is kind of a bad thing to do in SQL as it means that any index...
2015-12-10
591 reads
Blogs
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Trace Flag 1448 – Lessons from a Technical Interview
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Automatically generate tabular model partitions
Hi. I hope someone can give some useful suggestions. My workplace have a suite...
SQLPS and syspolicy_purge_history job
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Question of the Day
Locking Hierarchies
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate,
o_orderkey,
o_custkey,
o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;