Here’s a cool tip/reminder from a blog that I saw the other day – the startup parameters for SQL Server now has its own tab. Before you had to scroll to the end of the startup parameters and add a semicolon to the configuration, which was a pain. You never really could see all of them at once, and e...
[More]c3344bf6-8cfc-4213-88af-92e541f2e9f8|0|.0
Someone asked me the other day what blogs I follow. I guess I don’t follow too many, but if I had to recommend some, Aaron Bertrand has a really good blog and covers some good stuff. Tim Mitchell is a good friend and someone I consider a cool dude, and Jamie Thomson always posts some g...
[More]Posted in:
Beginner ,
TSQL Tags:
804026e4-6ab6-4834-8e15-5b74e7363c7b|0|.0
You might get the following whilst trying to attach a .sdf file (SQL Server Compact) in SQL Server Management Studio: Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) Additional Information: An exception occurred while executing a Transact-SQL statement or batch....
[More]d65232b2-0aab-4c9f-9c3b-a8023a228370|0|.0
An idea came over me last night…back over two years ago I wrote a few blogs on table variables, and was using one the other day. I remembered that they have a problem in some instances with transactions, and could possibly not be ‘rolled back’. It states in Books Online that the duration is short, b...
[More]8a4d9ffb-c7e4-4f85-bca4-925c03bf3568|0|.0
I’m seeing more and more information on SQL Server 2012 coming, including the Virtual Launch Event which is on March 7, 2012. Check out this MSDN post for the latest stuff. And, if you haven’t downloaded it yet, I suggest that you go grab it and start dorking with it. It’s pretty nice! I suggest as ...
[More]Posted in:
SQL Server 2012 Tags:
b0253037-b9cb-48f7-a7a8-b03134272fc3|0|.0
I see a bunch of emails flying back and forth concerning the PASS board member appointments. If you want a list of interesting blogs for reading, check out the below as supplied by PASS. Of course I would have like to have seen Sri get an appointment, but I’m not involved in all of that stuff,...
[More]Posted in:
Etc. (Off-topic) Tags:
e4b07b8a-7881-4d0b-b63e-0df9c3d8bc42|0|.0
I always like little tips and tricks when I see one from someone who picked it up out in the trenches, at a client location, rather than one in the lab. Here’s one from the MSDN folks; check this out and keep this in your toolbox in case someone gets a database put into single-user mode, and the act...
[More]51a6bac9-6d01-4c6b-ba1d-831f55de2860|0|.0
Just something a bit strange, when you insert a GUID into SQL Server, the letters are lower case. See the following. Fire up Visual Studio 2010 and run the following c# console app in debug mode:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Micr...
[More]9c30c713-7be2-4188-93ea-631c59a57460|3|5.0
SQL Server 2012 has given us a new team and a new blog – The SQL Server AlwaysOn Team Blog – to support one of the coolest features (I believe) in SQL Server 2012. If you haven’t read about AlwaysOn, or haven’t had a chance to do the kick ass SQL Server 2012 AlwaysOn Availabi...
[More]12c54ee6-e040-4bdd-a1b5-b688a22e3b8a|0|.0
Sequences in SQL Server 2012 are new, but sequences have been an ANSI standard for a long time. I first worked with sequences in Oracle 8.0 back in 2001. Applications back then in SQL Server 6.5 and 7 oftentimes created a sequence table; each time you wanted an ‘identity’, you went to a ...
[More]Posted in:
SQL Server 2012 ,
TSQL Tags:
fc9b15d0-4063-4d89-aaec-13ea74539d11|0|.0
Installing SQL Server 2008R2, you might get the following...SQL Server starts to load, and then it craps out:
Managed SQL Server Landing Page has stopped working
The problem is that – for SQL Server 2008R2 circa Jan 2012, you got to overly excited and downloaded and insta...
[More]7cde4432-3326-47e6-8a56-e8d0b329cf3d|0|.0
Making changes to an existing table – in this case NULLability – with indexes on the table and you may get the following error:
Msg 5074, Level 16, State 1, Line 2 The index 'idx_test' is dependent on column 'isDeleted'. Msg 4922, Level 16, State 9, Line 2 ALTER TABLE ALTER COLUMN isDel...
[More]40c699d0-a99d-4bec-b880-0b1d3be3cfb9|0|.0
TFS was just installed at my company, so I wanted to go out and take a look at the TFS SQL Server database jobs for database backups, transaction log backups, and anything else I could find. So I crack open SQL Server Management Studio (SSMS) on the server and start snooping around…to find no...
[More]43894e2c-9932-4833-9f59-8aa19952df1a|0|.0
Check out this link for a bunch of SQL Server 2012 Hands-on labs. Great stuff! Now I have something to do this weekend :) Lee ------------------ SQL Server Virtual Labs http://www.microsoft.com/sqlserver/en/us/learning-center/virtual-labs.aspx
Posted in:
SQL Server 2012 Tags:
f982424d-b0da-479c-b68a-15f97d20e5e6|1|5.0
I’ve created little utility functions for over 10 years now and I can honestly say that I don’t have a single one saved off somewhere to look back to. Actually, since I wrote one, they’ve changed the objects, methods, properties, etc. so much that it wouldn’t matter. So I’m dorking with scripting a ...
[More]b509fcfd-56ce-4af0-a468-ecbec66935c3|1|5.0
PASS has another event that they’re sponsoring, and it’s called SQLRally. Here’s a description:
PASS SQLRally regional events fill the gap between the free 1-day PASS SQLSaturday training events and the annual PASS Summit, the world's largest conference for the SQL Server commun...
[More]Posted in:
Etc. (Off-topic) Tags:
4b67ca9a-1662-4406-9f47-339c64cfa6b6|0|.0
Just perusing the MSDN and TechNet blogs today and came across a cool blog on Securing SQL Server Integration Services in the enterprise with respect to the SSIS Engine, SSIS packages, and the SQL Engine. I’m battling dealing with security problems where I work, mostly related to what was done in th...
[More]4807f4ac-ac77-4d6c-b805-aa8a0bba2444|0|.0