SQL Server with Mr. Denny:

Development


June 14, 2012  9:00 PM

When does SQLCLR launch?



Posted by: Denny Cherry
CLR, SQL CLR Procedure, SQL Server, SQL Server 2012

A change was made to the SQLCLR, as to when the SQLCLR is loaded.  In SQL Server 2008 R2 and below the SQLCLR component was loaded only when the “clr enabled” setting, which is controlled through sp_configure, is enabled.  Even with the SQLCLR is enabled on SQL Server 2008 R2 and...

June 11, 2012  9:00 PM

SQL Server 2012, SQLCLR and Max Server Memory



Posted by: Denny Cherry
CLR, SQL CLR Procedure, SQL Server, SQL Server 2012

When SQLCLR was first introduced in SQL Server 2005, one of the big complaints that I had with it was that SQLCLR could technically steal all the memory away from the SQL Server’s buffer pool by simply growing it’s memory pool which would cause the OS to request memory back from the SQL...


March 19, 2012  2:00 PM

Windows 8 Boots With No Network



Posted by: Denny Cherry
Beta, Networking, SQL Server, Windows 8

So I've run into a bit of a strange issue with Windows 8 on my laptop that I wanted to share in case anyone else runs into the same problem.  My basic problem is that about 50% of the time when my laptop boots up into Windows 8 it can't find the network.  I know that the WiFi card is working...


March 15, 2012  2:00 PM

My First Day with Windows 8



Posted by: Denny Cherry
Beta, Windows 8

So I've taken the plunge and installed Windows 8 Client Preview on one of my laptops.  The install process was pretty simple and straight forward.  The installer found my WiFi card so I was able to get everything up and running right out of the box.  The next thing to do was to install SQL 2012...


March 15, 2012  3:40 AM

Windows 8 does have a Start Menu, sort of



Posted by: Denny Cherry
Beta, Start Menu, Windows 8

Everyone says that Windows 8 doesn't have a start menu, and it's true there's no Start Button on the task bar like in the last several versions of Windows.  However if you press <Windows>+W you'll get a sort of start menu.


February 6, 2012  2:00 PM

Stop putting it off, it’s time to sign up for SQL Pre-Cons



Posted by: Denny Cherry
In Person Events, Performance, Query tuning, SQL Server, Tech Ed, Tech Ed 2012, Tech Ed Europe, Tech Ed North America

If you are headed to Microsoft's Tech Ed North America or Tech Ed Europe you should really look at signing up for a SQL Server Pre-Con.  The pre-cons are full day sessions focusing on a specific topic, led by an industry expert.  In the case of the SQL Server pre-con "Microsoft SQL Server...


February 6, 2012  2:00 PM

Drying Out a Wet Laptop



Posted by: Denny Cherry
Distaster Recovery, Laptop, SQL, SQL Server

The other day I had a VERY unpleasant situation happen.  I managed to dump a basically full 64oz (1.8 liter) cup of iced tea all over my desk.  In theory this shouldn't be a problem but it landed right on top of one of my laptops.  Thankfully the laptop was off but it was plugged in when this...


January 16, 2012  2:00 PM

When you don’t QA, there are problems



Posted by: Denny Cherry
SQL Server, Testing

Without a proper QA process things can end up going a little bit wrong.  Even the most basic of processes need to be checked and controlled, if they aren't then things can end up going a little wrong.  Just like these


November 7, 2011  2:00 PM

Slide Deck From Buena Park .NET User Group



Posted by: Denny Cherry
Development, Indexing, SQL Server

Last week on Wednesday night I had the privilege of presenting a session to the Buena Park .NET User Group.  The session that I gave was "Indexing for the .NET Developer".  The abstract for the session is: "In this session we will be looking at the...


February 8, 2010  11:00 AM

Using XMLNAMESPACES within a function



Posted by: Denny Cherry
Functions, T/SQL, XML

Recently one of my developers asked me to begin returning data from a function as XML instead of a comma separated list.  My thoughts on this was awesome, another cursor getting removed from the system.  I'll write a quick FOR XML AUTO, ROOT('root') at the bottom of the SELECT statement being...


Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: