Latest Blog Posts
I’ll start part 1 of the Microsoft System Center series, focused on what a SQL Server DBA should know about System Center, with System Center Operations Manager, or SCOM, with the SQL Server Management Pack. When you have licensed the System Center…
My original posting on System Center Operations Manager for SQL Server DBAs start in part 1 of the series here. Today, I want to take just a minute to give you some pointers in getting started using the System Center Monitoring Pack…
Come join us Thursday April 2nd for an Excel BI virtual chapter session at noon central with Pragmatic Work’s Devin Knight who will help us get started with PowerQuery.
Thu, Apr 02 2015 12:00 Central Daylight Time
Getting Started with Power Query by Devin Knight
GETTING STARTED WITH…
0 comments, 157 reads
Posted in Andreas Wolter SQL Server & BI blog (English / German) on 27 March 2015
My “Unit testing with SQL Server” article is now online on SQLServerCentral.com. A big thanks goes to Steve Jones (@way0utwes).
You can read it here.
Stay tuned! :)
Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test for. It works fine, just as it would with other code, but you need to understand that a CATCH still needs to re-throw an exception.
Here’s a short example. I’ve… Read more
Two weeks ago I attended SQLBits in London. This is probably the biggest SQL Server conference in Europe, and this time there were around 1,700 attendees in a special edition of SQLBits – the Superheroes edition.
Between the various sessions and the exhibition hall, I met a lot of people… Read more
Last year I purchased a Lenovo W530. Nightmares then ensued. Nice laptop if you just want to use it as a laptop, and only a laptop. Horror show if you need to present from it. So, I replaced it with an HP… which also gave me some troubles (try presenting… Read more
I have a customer who is having a problem with a load. He is getting a fair number of bad characters including some unicode characters. The unicode characters in particular are making it so those values won’t go into a varchar column. This isn’t an uncommon problem so when he… Read more
How many times have you said to yourself, “Someone should build an application that does [x]…”, or “Wouldn’t it be easy to add automation to [y]”, or “It would be a lot of fun to work on a project to build [z]”? For me, this has happened a lot, and… Read more
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly about using Excel 2013 and later. Much of the content will be a result of my daily interactions with business users and other BI devs. In order to not… Read more
Have you written a TRY..CATCH statement in T-SQL? I hadn’t done it for most of my career, since the construct hadn’t existed. As a result, my code over the years is littered with catching @@error in a variable and then acting on that result.
However I’m trying to do better,… Read more
Simple paramaterization occurs when the optimizer determines that a query would benefit from a reusable plan, so it takes the hard coded values and converts them to a parameter. Great stuff. But…
Let’s take this example. Here’s a very simple query:
SELECT ct.* FROM Person.ContactType AS ct WHERE ct.ContactTypeID =…
You may or may not have noticed it after installing SQL Server 2012: the designer interface in Visual Studio 2010/2012 has had a make-over. Nothing too drastic, but at least the undo button works. However, sometimes when you drag or move tasks/components on the canvas, they start to shake. A… Read more
After SQL Saturday Pordenone, I’ll keep speaking about DLM (aka ALM on databases) during the following events:
I haven’t been at this blogging thing an extremely long time, and I certainly haven’t been as consistent as I’ve wanted to (working hard on this though – at least one post a week!). There is no getting around it – blogging is time consuming. Especially technical blogging. My first… Read more
Many times we face space issues with our database. To resolve this problem SQL Server 2005 provided one more solution which is VARDECIMAL feature.
** VARDECIMAL feature exist in SQL SERVER’s Developer & Enterprise edition.
** This feature is not available in SQL Server 2005’s Standard… Read more
I’ll be traveling to CA next month for SQL Saturday #389 – Huntington Beach as well as a Red Gate DLM training session run by Ike Ellis. I’m assisting Ike in running a Database Continuous Integration class. It’s a paid for event, but you’ll learn how to set up and… Read more
ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance
Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice!