SQL Server

SQL Server Community

SQL Server Blogs

Kenneth Fisher
Follow /25 Mar 2015 at 1:00pm / SQL Server

Clean out all bad characters from a string.

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...
172 0 /
Follow /25 Mar 2015 at 11:32am / SQL Server

Danish SQL User Group General Assembly

For many years, the Danish SQL Server User group (under the PASS umbrella) has been stagnating !! So much stagnating that other successful initiatives have started. Some of my fellow members and myself really want to reinvigorate this group, which had...
84 0 /
Follow /24 Mar 2015 at 11:00am / SQL Server

Use the WordPress Revision Counter to Keep Shipping Posts

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...
113 0 /
Thomas LaRock
Follow /23 Mar 2015 at 2:20pm / SQL Server

HOW TO: Find When SQL Server Wait Stats Were Last Cleared

For years I have found myself often needing these three pieces of information with regards to SQL Server: When was the last time the server was restarted? When was the last time the SQL instance was restarted? When was the last time the SQL Server wait...
182 0 /
Derik Hammer
Follow /23 Mar 2015 at 2:00pm / SQL Server

SQL Saturday #381 – Richmond, VA

Last Saturday I attended #SQLSATRVA , which was SQL Saturday #381 . It was a blast! The day started off with the usual registration process. Thankfully, I remembered to print out and cut my SpeedPass in advance. The line to use the scissors was ridiculous...
113 0 /
Colleen Morrow
Follow /23 Mar 2015 at 2:00pm / SQL Server

Exam Prep 70-463: Executing packages in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and Slowly...
188 0 /
Kenneth Fisher
Follow /23 Mar 2015 at 1:00pm / SQL Server

0 to Speaker

Recently the last day to submit a session for the 2015 Pass Summit rolled around. I mention this because I actually submitted a session. This is the first time I’ve ever submitted something for the summit and only the third time I’ve submitted...
107 0 /
Chris Webb
Follow /23 Mar 2015 at 12:30pm / SQL Server

Benford’s Law And Power Query

Probably my favourite session at SQLBits the other week was Professor Mark Whitehorn on exploiting exotic patterns in data . One of the things he talked about was Benford’s Law, something I first heard about several years ago (in fact I’m sure I wrote...
251 0 /
Follow /21 Mar 2015 at 1:32pm / SQL Server

Parsing XML Child Nodes and Converting to DateTime with PowerShell

As part of my organiser role for SQLSaturday Exeter ( Training Day Information here and Saturday Information here ) I needed to get some schedule information to input into a database. I had read Steve Jones blog posts on Downloading SQL Saturday Data...
148 0 /
Follow /20 Mar 2015 at 9:19am / SQL Server

Tips & Tricks

Last week I saw Cathrine Wilhelmsen's ( b | t ) slides of her session at SQLBits XIV: Tools and Tips: From accidental to efficient DWH developer . If you haven't watched the session, go scroll through the slide deck at slideshare right away! It...
225 0 /
Chris Webb
Follow /19 Mar 2015 at 10:24pm / SQL Server

ConcatenateX() DAX Function In Excel 2016

This is the first of many posts on the new DAX functions that have appeared in Excel 2016 (for a full list see this post ). Today: the ConcatenateX() function. The mdschema_functions schema rowset gives the following description of this function: ...
162 0 /
Ed Elliott
Follow /19 Mar 2015 at 9:49pm / SQL Server

Free Professional Advice on Setting up Continuous Integration for Sql Server Databases

Calling all London/Sussex Sql Developers does this sound like you? Would you like to set up Continuous Integration or Continuous Deployment Do you want to get your databases under source control Have a high code coverage of your app but zero...
146 0 /
Ryan Adams
Follow /19 Mar 2015 at 6:21pm / SQL Server

Planning a High Availability and Disaster Recovery Plan in Madison, WI

I’ll be doing a precon for SQLSaturday #387 in Madison Wisconsin on April 10th, 2015 titled “Planning a High Availability and Disaster Recovery Plan” .  If you are in the area or thinking of attending this event, I would love to have...
146 0 /
James Serra
Follow /19 Mar 2015 at 3:00pm / SQL Server

Creating a large data warehouse in Azure

Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server in Azure Virtual Machine .  Which one is appropriate based on the size of the data warehouse?  What are some hardware...
211 0 /
Derik Hammer
Follow /19 Mar 2015 at 1:52pm / SQL Server

Statement was run under snapshot isolation but the transaction did not start in snapshot isolation

My organization enabled READ COMMITTED SNAPSHOT ISOLATION (RCSI) on one of our major systems before we entered a peaking operating cycle. We had tested the impact to our system and felt that it was pretty safe. About half way through our operating cycle...
142 0 /