Last Execution of a Proc
SQL Server is full of good stuff. There are plenty of features to be used. Plenty of applications to help...
2015-02-17
2,045 reads
Blog Posts
Q and A With SQL MVP Chris Shaw
This has been a long time in the making, back in 2011 I attended a session at PASS Summit by...
2015-02-17
953 reads
SQL Code Guard v2.7 released
Hola!
SqlCodeGuard v2.7 is just released.
To be brief - major changes:1. Added command line utility
2. Added scgallow(issue)/scgignore(issue`)to control which issues should be...
2015-02-17
1,576 reads
The Vacation Conundrum
Would I want unlimited time off? It’s an interesting question. I think I might like something more like a minimum...
2015-02-17
879 reads
T-SQL – Read CSV files using OpenRowSet
We can directly access a CSV file using T-SQL.
Input file
Configure server to run Ad Hoc Distributed Queries
sp_configure 'Ad Hoc Distributed...
2015-02-17 (first published: 2015-02-09)
15,624 reads
COOL Projects!
K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...
2015-02-16
53 reads
COOL Projects!
K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better, the killer feature for me is quickly deploying the...
2015-02-16
3 reads
COOL Projects!
K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...
2015-02-16
38 reads
Dealing with layered function calls
T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are...
2015-02-16 (first published: 2015-02-05)
6,283 reads
On Failure: Getting Up
In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...
2015-02-16 (first published: 2015-02-06)
5,951 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
CMS server query & temp tables
I am annoyed. We have a CMS server that has hundreds of servers saved...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers