I just got an emailer that SQL Server Magazine aka SQL Server Pro is now going all digital…and I’ll only receive two more printed versions of the magazine in the mail. I have always enjoyed looking forward to receiving SQL Mag in the mail each month for the past 12 years or so, and have seen a stead... [More]

Posted in: Etc. (Off-topic)  Tags:
lee posted on February 21, 2012 20:03
I was deleting some data in production the other day, and because of the existing indexes and data types, I was a bit constrained on how to remove the rows.  Using some of the things that I’ve previously mentioned in other “Deleting Data” blogs, I added something today that I thought was pretty... [More]

Posted in: SQL Server 2008/R2 , TSQL  Tags:
Tom Davis, Managing Consultant at Sogeti USA contributes the following blog entry for today. Entity Framework (EF) doesn’t play well with table-valued parameters. Remember that these are an excellent way to call a process once, rather than over and over, to send data to SQL Server. While some lo... [More]

Posted in: .Net , SQL Server 2008/R2  Tags:
SQL Server Sizing, HA and Performance hints has a blog out on the –T 1117 trace flag that I happened upon; there has been a lot of info about this trace flag, but I never really paid much attention to it outside of the context of tempdb. This blog reminds that the flag, when set, can affect file gro... [More]

lee posted on February 17, 2012 14:29
One thing I’ve noticed recently, over the last year or so, is the increasing problem in our large SQL Server community of writers not citing their sources of information as they should be doing.  I include folks over at SQLBlog.com, SQLServerPedia, personal blogs, SQLServerCentral.com, SQL Serv... [More]

Posted in: Etc. (Off-topic)  Tags:
I always like going to the new product launches…SQL Server 2000 was a big one, as well as SQL Server 2005. The latter was a the Dallas Convention Center if I remember correctly, and had a huge turnout. Always enjoy getting the goodies (pens, paper, hats, etc.) and meeting up with old friends. The li... [More]

Posted in: SQL Server 2012  Tags:
Another good tip for beginners -  remember that if you make a simple change in SQL Server Management Studio (SSMS) by opening up the table in design mode, you might see your entire IDE hang; the reason is because SQL Server could be doing a complete DML operation in the background, moving all o... [More]

Posted in: Beginner  Tags:
The Portuguese PFE SQL Server Team, no less, has posted a link to an updated KB entitled “How to choose antivirus software to run on computers that are running SQL Server. Check out the links for further info – here are the highlights that I took away: Exclude directories with .mdf, .ldf, and .n... [More]

Posted in: Vids , The Best of MSDN Blogs  Tags:
I’ve done a few blogs on SQL Server CE (Compact Edition) because I think it’s cool. I do not believe that it’s an enterprise-class relational database, but sometimes you may not need SQL Server Enterprise Edition to handle a given task. It’s free, and it doesn’t require a large or lengthy install. T... [More]

Posted in: Etc. (Off-topic)  Tags:
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:

by Lee Everest, M.S.

Info

Poll

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

Ads

Search


Month List

Calendar

«  May 2012  »
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910
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