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,243 reads
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
696 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)
27,410 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
1,989 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
734 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,043 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,303 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,581 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)
70,972 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,730 reads
Blogs
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Secure Azure SQL Server Backups Using Managed Identities
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
Forums
Update particular record in a table
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Internationalisation
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Size of DB on physical disk doesn't match Disk Usage by Table report
Hi everyone I am looking at the size of my db on disk (ie...
Question of the Day
Getting the TEXTSIZE
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers