SQL Server

SQL Server Community

SQL Server Blogs

Thomas LaRock
Follow /31 Mar 2015 at 11:31am / SQL Server

Presenting This Week: Enterprise Data World

This week I will be attending Enterprise Data World in Washington, DC. I’m excited to have been given the opportunity to present not one but TWO sessions at the premiere data management conference in the world. On Wednesday, April 1st, I will be...
8 0 /
Follow /31 Mar 2015 at 6:10am / SQL Server

Extending SSIS With .NET scripting

Earlier this year I got embarked on a book project together with Joost Van Rossum ( B | T ) , a dutch fellow MVP. A book about a subject that has always been very dear to me and crucial to the success of my work as an ETL developer. Namely how to extend...
68 0 /
Chris Yates
Follow /30 Mar 2015 at 2:00pm / SQL Server

Backups – They Are Needed, Who Knew?

Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at the end of the day if the data professional does not have a form of backup in place for his/her business needs you may, no you will,...
87 0 /
Kenneth Fisher
Follow /30 Mar 2015 at 1:00pm / SQL Server

Port numbers and SQL Server

I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are shocked, but it does happen on rare occasions. So what was I wrong about you might ask? One of the dev groups I support has been referring to their instances as...
91 0 /
Chris Webb
Follow /30 Mar 2015 at 1:00pm / SQL Server

NaturalInnerJoin And NaturalLeftOuterJoin DAX Functions In Excel 2016

Continuing my series on new DAX functions in Excel 2016, here are two more: NaturalInnerJoin() and NaturalLeftOuterJoin(). Both do pretty much what you’d expect. Consider the following two tables in an Excel worksheet, called ColourFruit and FruitPrice...
82 0 /
Mark Broadbent
Follow /30 Mar 2015 at 7:52am / SQL Server

How to install SharePoint 2013 on Windows 2012R2

If you want to jump straight to the condensed solution, then please feel free to go to the Condensed Installation instructions below. If you find this post useful or have any feedback then please leave me a comment so that I know my efforts were not wasted...
86 0 /
Ayman El-Ghazali
Follow /29 Mar 2015 at 1:16pm / SQL Server

SQL Server 2014 BI دورة تمهيدية شاملة في

الزملاء الأعزاء من العالم! السلام عليكم و رحمه الله و بركاته أقدم لكم دورة تمهيدية شاملة في SQL Server 2014 BI. وتقدم هذه الدورة التدريبية باللغة العربية، وتهدف إلى المساعدة فى التقديم للمفاهيم الأساسية للمهنيين المتخصصين فى قواعد البيانات عامه وبخاصه...
121 0 /
Melissa Coates
Follow /27 Mar 2015 at 6:55pm / SQL Server

Monitoring the SSAS Connector in the Power BI Preview

Welcome to part 3 of a 3-part series on using the SSAS Connector with the new Power BI Preview. This information is as of early March 2015 and is subject to change as the Power BI Preview evolves. Part I: Overview of Using Analysis Services Data in the...
117 0 /
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...
229 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...
117 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...
142 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...
224 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...
152 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...
221 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...
141 0 /