|
|
|
|
Latest Blog Posts
-
|
Over the past few years of using datadude (aka DBPro aka Visual Studio Database Projects) I have fallen prey to a peculiar little nuance – if you forget to supply a value for a sqlcmd variable then it will simply use a default and often that is not the...
|
-
|
You may disagree, but I believe it is a good practice to cluster all the SQL Server instances. That is, even when you plan to run a SQL Server instance on a single machine, you should install it in a single node cluster. The primary advantage is that...
|
-
|
The upcoming release of SQL Server 2012 has a lot of new features for business intelligence developers to love. The free preview of Introducing Microsoft SQL Server 2012 (Microsoft Press, 2012) does not include the chapter on Analysis Services, but you’ll...
|
-
|
I am honored to be presenting my first SQL Saturday session in Redmond on the 25th of this month. The session will be a PowerShell basics class, emphasis on helping people who might be starting out with PowerShell, or feel intimidated by PowerShell’s...
|
-
|
I recently did a Rick Review of the Day 3 Keynote from the 2008 PASS Community Summit that featured Dr. DeWitt speaking on new technology that ended up in the Parallel Data Warehouse (PDW) edition of SQL Server 2008 R2. I decided to also listen again...
|
-
|
Am I stuck in the past? Not really, but I like to blog about the recordings that I have recently watched. There are a lot of recordings out there on the PASS website and other places. Recently I have had the good fortune of exploring some of the neat...
|
-
|
As you might (or not) know, I travel a lot for work and, when possible, I always try to speak at local user groups. It is fun and I always learn a lot by speaking with other professionals like me. Being in Lisbon next week, I’ll deliver a speech at Microsoft...
|
-
|
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....
|
|
|
|
|
|