Attention to all who would post. The Politics Of 36 Chambers. Who Writes This Stuff? Get Us On The Go! Follow This Blog Via E-Mail. Enter your email address to follow this blog and receive notifications of new posts by email.

SQL Server, PASS, and other data mishaps. Send me an email! I Spout off about Bacon. An interesting topic given the season and something that is near and dear.

Using a gMSA with SQL Server. Comparing Inline and Multi-Statement Table-Valued Functions. Does a Clustered Index really physically store the rows in key order? .

Random SQL Things I Find Useful. Thursday, July 15, 2010. There has been some discussion today on twitter about extended properties. A while back I wrote an article for MSSQLTips about using extended properties to create a Data Dictionary. Tuesday, July 13, 2010. I received an email last week informing me that one of my sessions had been accepted for the 2010 PASS Summit. Enforcing Compliance with Policy-Based Management.

MERGE Learning AS Target USING SQL. Trying to become someone in the SQL Community. Make sure the package exist on the SQL Server and you have the correct credential to access it. Can anyone help me with this? June 20, 2011.

Things about Software Architecture, . Wednesday, June 6, 2012. I can say this book is a really great resource for everyone who wants to know how CLR internally works. Give yourself a few seconds before you scroll down to read the disclosure. You think you got it? Whenev.

SQL Server Fixed Role Permissions. Some of my recent articles have been focused on permissions and security. You can catch up with a couple of those articles here. This article will help to reveal the permissions granted to the various roles and maybe a gotcha or two. What are the fixed roles again? These default roles do have a unique set of permissions fo.

Or, another way to put it, in most cases, shooting yourself in the foot. I was not aware that the cumulative update. For SQL Server 2008 back in June included a switch that allows you to turn parameter sniffing off within SQL Server. The New Path To MCM. PASS Summit 2010, Day 3 Key Note.

Our site has moved and is now being hosted at. Please adjust your links and check out the page there for the schedule for upcoming meeting information! .