You might get the following error when trying to connect to a SQL Server CE edition on a network share SQL Server Compact does not support opening database files on a network share. (System.Windows.Forms).     So much for me trying to put my SQL Server CE database on my cluster h... [More]

I have a couple of blogs extoling the greatness of the latest virtual labs that Microsoft has created for you and me…it might help some folks to actually review some of the features of SQL Server 2012 first before going and doing a lab. This eBook has some information that may help introduce the new... [More]

Posted in: The Best of MSDN Blogs  Tags:
In the other post I showed one way to insert data into SQL Server CE; here I’m going to extract data from it using only the SSIS delivered tasks. Why you ask? If you’ve consulted as I have for several years, you know that in some shops, notably BI shops, that the true hardcore BI folks do not do cus... [More]

Posted in: SSIS  Tags:
  Someone here at work is going to use SQL Server Compact Edition (SQL CE) to do some data storage, so I wanted to check it out as well since I haven’t used that version before. Google shows some folks having problems connecting to it and pushing/fetching data via SSIS, some links below ... [More]

Posted in: SSIS  Tags:
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]

Posted in: The Best of MSDN Blogs  Tags:
  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:
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]

Posted in: SQL Administration  Tags:
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]

Posted in: TSQL  Tags:
lee posted on January 25, 2012 16:46
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:
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:
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]

Posted in: The Best of MSDN Blogs  Tags:
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]

Posted in: TSQL  Tags:
Lee posted on January 16, 2012 19:38
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]

Posted in: SQL Administration , SQL Server 2012  Tags:
Lee posted on January 15, 2012 11:14
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:
Lee posted on January 14, 2012 15:00
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]

Posted in: SQL Administration , SQL Server 2008/R2  Tags:
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]

Posted in: Beginner , SQL Administration , TSQL  Tags:
Lee posted on January 11, 2012 12:00
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]

Posted in: Etc. (Off-topic) , SQL Administration  Tags:

by Lee Everest, M.S.

Poll

Do you use Azure or cloud in your organization?
Show Results

Ads

Search


Month List

Calendar

«  February 2012  »
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
2728291234
567891011
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2012 Lee Everest's SQL Server, etc. weblog