Stress Thoughts-Part 4
Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes...
2012-03-30
1,610 reads
Blog Posts
An Amusing New Chapter of My Career
Starting next week, that’s the first week of April, this will be my new office. Well, not really, but I’ll be working for the company that hosts this coaster,...
2012-03-29
11 reads
An Amusing New Chapter of My Career
My New Office
Starting next week, that’s the first week of April, this will be my new office. Well, not really,...
2012-03-29
1,732 reads
Caveats of a CONTROL SERVER permission
Today morning I was working on one of the server to complete the regular documentation of security audit with details...
2012-03-29
1,943 reads
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,012 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,170 reads
Excel Source The Output Column Failed Because Truncation Occurred
In an SSIS package you have the option to choose from a wide range of source from Flat Files to...
2012-03-29 (first published: 2012-03-23)
3,579 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,308 reads
Save yourself from despair with full database documentation
Your ability to document thoroughly will determine your efficiency and productivity when it comes to managing your SQL Server databases....
2012-03-29
2,732 reads
SQLSaturday #107 Houston
About 3 weeks to go until SQLSaturday #107 at YES Prep Public Schools - North Central Campus, 13703 Aldine-Westfield, Houston, TX,...
2012-03-29
1,335 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers