|
|
|
|
Latest Blog Posts
-
|
My mind was wandering today after reading Andy Leonard's excellent post Name Those Connections and it occurred to me that due to SQL Server 2012 including an SSIS Server there may be an opportunity to leverage Policy-Based Management (PBM) for ensuring...
|
-
|
When creating Connection Managers in SSIS, take a moment to click the “All” page and set a value in the Application Name property. In SSIS 2008+, a default value is applied to this property. It’s useful but it contains a GUID. Yuck. I prefer to enter...
|
-
|
Beginning a transaction only when @@TRANCOUNT=0 might not improve performance at all. At least, I did not notice any difference whatsoever. No matter if I use this pattern: BEGIN TRAN ; -- (snip) COMMIT ; or a more complex one: DECLARE @trancount INT...
|
-
|
Robert Davis (a.k.a. @SQLSoldier ) and yours truly have submitted a Pre-Conference for SQL Rally 2012 in Dallas, TX called “Demystifying Database Administration Best Practices”. We think it’s going to be an epic session with just loads and loads of tips...
|
-
|
Although there are some audio issues, the recording and code for the Linchpin People microTraining session on SSIS Package Configurations is now live! :{>...
|
-
|
Three weeks ago I published a blog post Get the SQLBits agenda in your phone's calendar where I said: If you want to get the SQLBits calendar onto your smartphone then the easiest way to do it is add my calendar [containing all SQLBits sessions] to whichever...
|
-
|
Developing in Windows Azure is at once not that much different from what you’re familiar with in on-premises systems, and different in significant ways. Because of these differences, developers often ask about the specific process to develop and deploy...
|
-
|
We are going very close to the release of SQL Server 2012 and after using Analysis Services 2012 for almost one year in a relatively small number of scenarios, I’m really curios to see the questions and the issues that will emerge when its adoption will...
|
-
|
During SQL Server 2012 RC0 setup (specifically when upgrading), you may have noticed upgrade rules regarding Lock Pages in Memory (LPIM): However, for most folks, these rules always pass, whether or not they are actually using LPIM. I wanted to run a...
|
-
|
Introduction This post is the fifty-first part of a ramble-rant about the software business. The current posts in this series can be found on the series landing page . This post is about communication. On Being Clever I enjoy listening to a good comedian...
|
-
|
I've been working on a team with Roger Doherty building parts of what's now become the SQL Server 2012 Early Adoption Cook Book . So, if you work on the bleeding edge of SQL Server and are keen to get your head around what's coming, this is a seriously...
|
-
|
To ensure atomicity of transactions, we can use XACT_ABORT ON or wrap the transaction in TRY block and rollback in CATCH block. In some cases, the XACT_ABORT ON approach uses noticeably less CPU. I am posting repro scripts. Please run them, tweak them,...
|
-
|
Wrapping related changes in a transaction is a good way to ensure data integrity. Besides, in some cases it just runs noticeably faster, using less CPU. As usual, I am posting repro scripts, which you can run, tweak, and see for yourself. Environment...
|
-
|
I’ve released couple of hours ago the SP2 of my DTLoggedExec tool. For those who don’t know it, it’s a DTEXEC replacement, useful to execute SSIS and having logging provided right from the engine and not from the package itself. More info can be found...
|
-
|
I will be delivering another free, online MicroTraining on SSIS Package Configurations Tuesday, 7 Feb 2012, at 10:00 AM EST. Join Andy Leonard as he demonstrates uses of SSIS Package Configurations for externalizing SSIS package variable values. Register...
|
-
|
These days if you get a new server-class machine to run SQL Server, you can almost be 100% sure that it’ll be running on NUMA hardware. The recent AMD Opteron and Intel Nehalem-based processors are all built on some form of NUMA architecture. The current...
|
-
|
This is a continuation of the books I challenged myself to read to help my career - one a month, for year. You can read my first book review here . The book I chose for January 2012 was: The Elements of Persuasion by Richard Maxwell and Robert Dickman...
|
-
|
My 4yo son keeps asking me why I should leave home so often to attend SQL conferences around the world and today, after a couple of days of snow, he discovered a good reason, along with the best place for the SQLBits scarf....
|
-
|
Once upon a time I blogged at http://consultingblogs.emc.com/jamiethomson but that ended in August 2009 when I left EMC. There is a lot of (arguably) valuable content over there however certain events in the past leave me concerned that that content is...
|
-
|
What happens when NUMA affinity meets query parallelism? It gets no respect! SQL Server allows you to affinitize a TCP port to a specific NUMA node or a group of NUMA nodes. Books Online has an article on How to: Map TCP/IP ports to NUMA Nodes . And this...
|
|
|
|
|
|