Archives: March 2012
here you can use the query below:
Reflections on Leaving Microsoft
Several members of my SQLFamily have made adjustments to their career path recently. Several of us got together for #SQLNomz yesterday to celebrate our job changes, though granted, we don’t generally require an excuse to get together. Yesterday (Friday,… Read more
0 comments, 873 reads
Posted in SQL Server Soldier :: News from the frontlines of the database wars on 31 March 2012
My last column, Misadventures in TDE: How to Restore an Encrypted SQL Server Database Completely Wrong, described a comedy of errors of my own making. This week’s mistutorial likewise teaches through bad example, by the same heuristic principle that experiencing what can go wrong with a task can sometimes… Read more
I was just looking at the schedule for Houston, an amazing 10 tracks for this event on April 21, 2012. I’ll be doing two presentations, one on professional development plans and another on SQL security for developers. This will be my first time at the Houston SQLSaturday and really looking… Read more
I wrote a post recently about setting the DAC port for an SQL instance.
I now do this as a matter of course on all of my SQL instance as I manage most of them remotly.
However, from time to time I discover instances that have had… Read more
I returned late last night from the Spring DevConnections event, delivering three sessions in the SQL Server Connections conference. I talked about Encryption, Filestream/Filetable, and Contained Databases. Always cool to see your name in print
It was a nice event, with decent crowds in the… Read more
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may not have had a chance to see. Also a chance to bring back to the forefront posts that some may have seen but forgot about.
If you have… Read more
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio, and now supports SQL Server 2012 (including tabular mode) and Visual Studio 2010 (SSDT). Version 1.6 can be downloaded here, and read up… Read more
Recently I suffered through a frustrating and contentious meeting, and that was stressful. I needed a walk, a few minutes to sort out why I was stressed, but instead I had to step right into another meeting. It was a follow up meeting to build out an implementation plan for… Read more
SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.
On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition. I have done this multiple times with no issues. The “kicker” was that the upgrade required a 48-hour turnaround time but no installation media for SQL Server Enterprise… Read more
Welcome to the show! I’ll be liveblogging today’s keynote here at SQLBits X in London.
There’s no need to refresh your browser folks, we’re technology savy here at SQLBrit don’t you know and using a LAMP stack Send your Tweets to @SQLBrit and keep an eye on the #SQLBits hash… Read more
SQL Saturday Jacksonville is just under a month away (April 28) and I’m happy to announce the we recently released the schedule for the event. We have a great line up of speakers with a variety of topics for both DBAs and Business Intelligence developers. You can register to attend… Read more
Remember, in addition to traditional DBA topics, the event will have some topics of interest to developers that work with SQL…
Starting next week, that’s the first week of April, this will be my new office. Well, not really, but I’ll be working for the company that hosts this coaster, Six Flags. I’ll be overseeing all the SQL Server stuff for the entire organization. That means the back… Read more
I will be a busy little beaver today, presenting three sessions at the Spring 2012 Connections Conference, the first one at 8AM! Hopefully enough people will be able to get up by then and join me. It should be a lot of fun!
SQL301: Scaling SQL Server 2012
Your ability to document thoroughly will determine your efficiency and productivity when it comes to managing your SQL Server databases. Aside from the question of productivity, there’s always the concern of having to come across with problems relating to the unfamiliarity of vendor databases (this is particularly true with third-party… Read more
One of the problems with databases in SQL Server is the dependency of the database on various parts of the host instance. In SQL Server 2012 there is an enhancement to the database format that allows for partial containment of your database, and will make the movement, migration, and management… Read more
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However, when the data is simple and limited I avoid using it (too lazy to click through 6 screens… ) instead I generate INSERT statements using CONCATENATE function in Excel… Read more