Surface: Standard Onscreen Keyboard
If you feel that the default on-screen keyboard on the Surface RT isn't sufficient, you can enable what I would...
2012-11-19
1,249 reads
New York City .NET
SQL in the City - New York 2012
I was able to attend the SQL in the City event in New York this past Friday. I highly recommend...
2012-10-01
700 reads
PowerShell: Redirecting Console Output and Error Output to a Variable and E-mailing it
I recently had the need to script the execution of a command-line utility and thought it would be a good...
2012-08-29 (first published: 2012-08-28)
28,125 reads
Fix: Crystal Reports Shows Red X Across Entire Page When Report Run Inside Visual Studio
I was googling (with Bing AND Google) like crazy for a solution to this, but didn't find one from any...
2012-08-14
2,025 reads
Enabling "Open Project Folder" for project types that don't support it
One annoying thing about SSIS (2008) and some of the other project types in Visual Studio is the lack of...
2012-07-18
752 reads
A Pattern for PIVOT
Use of the PIVOT operator in T-SQL has always been tantalizing yet confounding to me. It offers the promise of...
2012-07-08
2,052 reads
Excellent SSIS 2012 Upgrade Video
This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...
2012-06-24
1,310 reads
Another Way To Insert Many Rows Very Fast From Your .NET Application
There was a great deal of feedback to my previous post One Way To Insert Many Rows Very Fast From...
2012-05-15
3,605 reads
One Way To Insert Many Rows Very Fast From Your .NET Application
This is my attempt to explain something that I have wanted to figure out for a long time. I have...
2012-05-15 (first published: 2012-05-11)
71,073 reads
One Way to Work Around the .NET Setup Project’s Picky Version Number Behavior
If you don’t change the version number of your .NET project output every time you create a setup package, you...
2012-05-10
1,735 reads
Blogs
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers