SQL Server

SQL Server Community

SQL Server Blogs

Chris Webb
Follow /17 Apr 2015 at 8: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...
83 0 /
Jen McCown
Follow /16 Apr 2015 at 3: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...
100 0 /
Colleen Morrow
Follow /16 Apr 2015 at 2: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...
104 0 /
Kenneth Fisher
Follow /16 Apr 2015 at 12: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...
93 0 /
Dinesh Asanka
Follow /16 Apr 2015 at 4: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...
98 0 /
Dinesh Asanka
Follow /16 Apr 2015 at 4: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,"...
97 0 /
Dinesh Asanka
Follow /16 Apr 2015 at 3: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...
53 0 /
Dinesh Asanka
Follow /16 Apr 2015 at 3: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
53 0 /
Melissa Coates
Follow /16 Apr 2015 at 1: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...
44 0 /
Larry Leonard
Follow /15 Apr 2015 at 6:39pm / SQL Server

Display Fragmentation on All Indexes in Current Database

This code displays the fragmentation on all indexes in the current database. (It excludes empty tables.) -- SQL Server 2005+. Show index fragmentation on all tables on current database. set nocount on declare @DbId smallint set @DbId = db_id() select...
45 0 /
Larry Leonard
Follow /15 Apr 2015 at 6:35pm / SQL Server

Display Stale Index Statistics

This query displays all the index statistics in the current database that are more than 'n' days old. -- When were Statistics last updated on all indexes more than 7 days ago? select o.name as 'Table Name' , i.name as 'Index Name'...
45 0 /
James Serra
Follow /15 Apr 2015 at 3:00pm / SQL Server

Types of NoSQL databases

A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases.  NoSQL is often interpreted as Not-only-SQL to emphasize that they may also support SQL -like...
55 0 /
Follow /15 Apr 2015 at 2:30pm / SQL Server

Quickly Check If SSL For SQL Is Enabled

Reading Time: 2 minutes To quickly check SSL is configured on your SQL Server you can run the following query. SELECT session_id, encrypt_option FROM sys.dm_exec_connections This query dumps the information about the connections to your SQL Server and...
49 0 /
Follow /15 Apr 2015 at 1:00pm / SQL Server

How to Write Queries – Understand your Database Table’s Meanings and Relationships – Step 1

This is the second of four articles in a series explaining the three simple steps I take to writing complex SQL statements.  The series starts with this introductory article. All the examples for this lesson are based on Microsoft SQL Server Management...
55 0 /
Larry Leonard
Follow /14 Apr 2015 at 4:33pm / SQL Server

CMS: Find All Databases in all Servers that don't have a Specified Table

This code is for CMS (Central Management Servers), and displays all the databases on all the servers that don't have a specified table. -- For all user databases in all servers, which ones don't have a "Customer" table? set nocount...
127 0 /