The current set of DMVs and DMFs is staggering; I counted I think 170 maybe in SQL Server 2005, and I'm sure that we're approaching the 1 million mark for SQL Server 2008 R2.  A smart DBA probably has a nice library of them now...I"m not smart and have to go look them up whenever I use the... [More]

Posted in: The Best of MSDN Blogs  Tags:
Lee posted on August 28, 2010 08:51
I always notice little things like this: Maybe the descriptor should have read..."built-in function MAX(expression) RETURNS MAX <datatype> Lee   ------------------------ Ever heard the expression..."You get what you pay for?"

Posted in: SQL Server 2008 , TSQL  Tags:
Lee posted on August 28, 2010 08:37
A friend who I’ve worked with on projects sent me some code the other day that had the below syntax; I had to quickly point out that she needed to be careful when using this type of construct.  Set up the minimal example by running the following code. We’ll create two tables and then OUTER join... [More]

Posted in: TSQL  Tags:
I certainly enjoy working with other DBAs; every time that I open SSMS and start tapping on the keyboard, I usually learn something new each and every day, and when I get to work with others directly, I learn things at an even faster rate.  Navigation tips, or code tricks, some shortcut that yo... [More]

Posted in: SQL Administration  Tags:
Lee posted on August 20, 2010 07:18
I like to visit the Microsoft Download page every so often see what Microsoft has recently released for SQL Server, and the other day they came out with new versions of the SQL Server Migration Assistant (SSMA) for Oracle, Access, MySQL, and Sybase.  They're located here; check them out for doi... [More]

Posted in: SQL Administration  Tags:
Lee posted on August 16, 2010 14:51
Wow! Idera and MSSQLTips.com are giving away a free trip to SQL PASS, all expenses paid.  Great bargain. Head over to this link and sign-up!   Lee Everest   --------------------------- Nurse Ratched: If Mr. McMurphy doesn't want to take his medication orally, I'm sure we can arra... [More]

Posted in: Etc. (Off-topic)  Tags:
lee posted on August 11, 2010 15:59
I blogged awhile back on a super-cheesy, simpleton, plane-jane, not worth a whole lot TSQL script to test transactions/second on a SQL Server.  The reason that I use it is because 1) it’s super cheesy and simple, and seems to work well compared to perfmon transactions/second, and 2) I’ve had it... [More]

Posted in: SQL Server 2008  Tags:
Lee posted on August 10, 2010 18:02
Here’s a pretty slick blog from the SQL Azure team – this one is on checking your database size for your Azure databases.  I never thought of it, but are they managing with AUTO GROW?  I hope not, since we all know to stay clear of that ALTER command like the plague, right???!!!  Anyw... [More]

You might get the following error when connecting to SQL Azure: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections The reaso... [More]

Posted in: SQL Server 2008  Tags:
Training for SQL Server. That's all that I see anymore everywhere that I look. From Microsoft's sites (developer resources, TechNet, Channel 9, MSDN blogs) to SQL Saturday, love boats, blogs that list training resources, companies everywhere offering training, national conferences, SQL Lunch, T... [More]

Lee posted on August 5, 2010 22:22
Microsoft released a one-month pass to learn Windows and SQL Azure, so if you don’t have a subscription already, check out this link.  It’s a cool offer but lasts only one month after you sign up, so you have to make sure and dork with it in a hurry before it expires.  If you go to the Win... [More]

Posted in: SQL Server 2008 , Etc. (Off-topic)  Tags:
Lee posted on August 5, 2010 08:19
I suggest checking out the SSWUG Ultimate Virtual Conference. Looks like a pretty good list of training courses (70+) and speakers (they're all MVPs and big-name guys that you've probably heard of) for this virtual event.  Prices seem to be reasonable, and the topics covered are good ones. ... [More]

Posted in: Etc. (Off-topic)  Tags:
Lee posted on August 3, 2010 06:38
Over on Microsoft Connect, someone submitted the following problem: Package variables defined in SSIS as type DATETIME can only represent values as granular as 1 second, yet SQL Server's DATETIME datatype supports milliseconds. This leads to a loss of precision when populating a da... [More]

Posted in: SSIS , SQL Server 2008  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