SQL Server

SQL Server Community

SQL Server Blogs

Follow /20 Apr 2015 at 9:46pm / SQL Server

In-Memory OLTP: Part 3 – Checkpoints

This post follows on from In-Memory OLTP: Part 2 – Indexes So far in this blog series memory optimised tables have been created with the durability option of SCHEMA_ONLY meaning that data will not be retained. However there is another durability...
60 0 /
Larry Leonard
Follow /20 Apr 2015 at 4:19pm / SQL Server

Find Orphaned MDF, NDF and LDF Files on All Drives

Sometimes you run across a server that for one reason or another is full of MDF, NDF, and LDF files that look to be months or years old. Of course, you can't go by the Date Modified timestamp of these files in Windows Explorer, but still, when you...
72 0 /
Follow /20 Apr 2015 at 3:30pm / SQL Server

SQL Saturday 413 news from the front

It is a lot of work to plan a SQL Saturday, and also a lot of  fun. The third edition of SQL Saturday in Denmark will be no exception. The team is already putting a lot of effort in finding and contacting sponsors, which luckily are often more than willing...
68 0 /
Follow /20 Apr 2015 at 1:00pm / SQL Server


HOST_ID and HOST_NAME Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement.  You can use this to record what workstation the transaction came from in your application or business intelligence...
80 0 /
Kenneth Fisher
Follow /20 Apr 2015 at 1:00pm / SQL Server

The hidden security of msdb

To be fair it’s not actually hidden, just not so well known. Have you ever wondered how to grant permissions to create/modify jobs? How about SSIS packages? Every database has the following built in roles: db_accessadmin db_backupoperator...
68 0 /
Dinesh Asanka
Follow /20 Apr 2015 at 3:45am / SQL Server

Microsoft Halts SQL Server 2014 SP1 Downloads

A bug surfaces soon after the release of SQL Server 2014's first service pack, forcing Microsoft to temporarily disable downloads of the update. Microsoft's attempt at squashing SQL Server 2014 bugs ran into a bug of its own. The company released...
101 0 /
Chris Webb
Follow /17 Apr 2015 at 9:25am / SQL Server

Building A Reporting Solution Using Power Query

The video of my SQLBits conference session “Building a reporting solution using Power Query” is now available to view (for free) on the SQLBits website: http://sqlbits.com/Sessions/Event14/Building_A_Reporting_Solution_Using_Power_Query It’s not your...
105 0 /
Jen McCown
Follow /16 Apr 2015 at 4:25pm / SQL Server

SQL Server 2014 SP1 released, and revoked

Just a brief note today to point to an article by Time Ford on SQLMag.com announcing that SQL Server 2014 SP1 has been released, and then pulled almost immediately: The problem is there was a problem with the patch. I can’t go into details until...
121 0 /
Colleen Morrow
Follow /16 Apr 2015 at 3:00pm / SQL Server

Exam Prep 70-463: Master Data Services Models

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...
118 0 /
Kenneth Fisher
Follow /16 Apr 2015 at 1:00pm / SQL Server

Adding, altering or removing multiple columns from a table

I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing 4 old ones, renaming 4 and then altering the datatype for those 4. I find these kinds of requests rather entertaining in a simplistic sort...
115 0 /
Dinesh Asanka
Follow /16 Apr 2015 at 5:13am / SQL Server

SQL Server 2014 Service Pack 1 is now available

One year ago, Satya Nadella spoke in San Francisco to launch SQL Server 2014 . Today, Microsoft has to announced the release of SQL Server 2014 Service Pack 1 (SP1). The Service Pack is available for download on the Microsoft Download Center . As part...
115 0 /
Dinesh Asanka
Follow /16 Apr 2015 at 5:06am / SQL Server

The World According to DBAs

Database administrators (DBAs) are at the frontline of data management in most enterprises, identifying and often choosing to adopt new technologies. According to a new survey of DBAs, "While Hadoop and NoSQL are exciting new technologies,"...
115 0 /
Dinesh Asanka
Follow /16 Apr 2015 at 4:50am / SQL Server

Microsoft Announces GA of Azure DocumentDB Managed NoSQL Document Database Service

Microsoft has announced that the Azure DocumentDB database service is now generally available offering a fully managed NoSQL document database service that allows applications to query and process JSON data at scale. Microsoft has also released a new...
70 0 /
Dinesh Asanka
Follow /16 Apr 2015 at 4:47am / SQL Server

Microsoft To Kill SQL Server 2005 Support in 2016

Organizations running SQL Server 2005 will be cut off when it comes to official support next year, Microsoft announced this week. http://mcpmag.com/articles/2015/04/15/sql-server-2005-support.aspx http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
68 0 /
Melissa Coates
Follow /16 Apr 2015 at 2:34am / SQL Server

Keeping Up with New Information with RSS, Twitter, and Read Later

I wanted a solution to view the RSS feeds of my favorite bloggers in the same place as the items I've tagged in my 'read later' app. This single place needs to be available on my Windows 8 device (a Surface Pro 3 which I dearly love), preferably...
64 0 /