SQL Server

SQL Server Community

SQL Server Blogs

sqlkris
Follow /1 Apr 2015 at 5:48pm / SQL Server

What is a Data Dictionary?

What is a Data Dictionary? In SQL Server the data dictionary is a set of database tables used to store information about a database’s definition.  The dictionary contains information about database objects such as tables, indexes, columns, datatypes...
66 0 /
Derik Hammer
Follow /1 Apr 2015 at 3:00pm / SQL Server

Database Deployment Work Flow with SQL Server Data Tools (SSDT)

Happy April Fools Day everyone! I hope that you do not spend too much time reading completely false blog posts today. I, for one, promise that this post is not an April Fools Day joke. Feel free to read on without fear of frustration. Today I wanted...
62 0 /
Kenneth Fisher
Follow /1 Apr 2015 at 1:00pm / SQL Server

Microsoft buys the dictionary

It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as a noun. Microsoft has decided to put it’s money where it’s mouth is and has announced today that they have...
76 0 /
Michael J. Swart
Follow /1 Apr 2015 at 1:00pm / SQL Server

Some Tweets I Drew

Last week I asked for people to give me illustration ideas on twitter using the hashtag #SwartDrawsTweets . Thanks for everyone who gave me suggestions. Here are a few of them. The Stig Brent Ozar tweeted: @Jorriss @MJSwart Running Enterprise Edition...
64 0 /
Chris Webb
Follow /1 Apr 2015 at 12:30pm / SQL Server

BI Survey 15

It’s BI Survey time again! BI Survey is the largest annual survey of BI users in the world, so if you want to share your feelings on Microsoft BI tools or whatever else you’re using then this is the opportunity to do it. As in the past, in return for...
64 0 /
Vinoth Nm
Follow /1 Apr 2015 at 11:51am / SQL Server

Create SQL Azure Database(PaaS)

Today we can see the step by step procedure to create SQL Azure database(PaaS),As mentioned in the previous couple of articles any Microsoft Cloud based service you need a Azure Subscriptio n ( http://azure.microsoft.com/en-us/pricing/ ); Select SQL database...
76 0 /
Thomas LaRock
Follow /31 Mar 2015 at 12:31pm / 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...
91 0 /
regbac
Follow /31 Mar 2015 at 7: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...
94 0 /
Chris Yates
Follow /30 Mar 2015 at 3: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,...
109 0 /
Kenneth Fisher
Follow /30 Mar 2015 at 2: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...
117 0 /
Chris Webb
Follow /30 Mar 2015 at 2: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...
98 0 /
Mark Broadbent
Follow /30 Mar 2015 at 8: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...
107 0 /
Ayman El-Ghazali
Follow /29 Mar 2015 at 2:16pm / SQL Server

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

الزملاء الأعزاء من العالم! السلام عليكم و رحمه الله و بركاته أقدم لكم دورة تمهيدية شاملة في SQL Server 2014 BI. وتقدم هذه الدورة التدريبية باللغة العربية، وتهدف إلى المساعدة فى التقديم للمفاهيم الأساسية للمهنيين المتخصصين فى قواعد البيانات عامه وبخاصه...
138 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...
130 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...
248 0 /