SQL Server

SQL Server Community

SQL Server Blogs

Chris Webb
Follow /25 Nov 2014 at 9:57pm / SQL Server

Power Query Now Works With SSAS

I normally don’t bother blogging when one of the Power Query monthly updates gets released – the posts on the Power BI blog have all the details and there’s nothing more to add. This month’s update, though, sees Power Query able to use SSAS Multidimensional...
30 0 /
sqlbischmidt
Follow /25 Nov 2014 at 2:16am / SQL Server

BIML: Columbus SQL Server User Group

I am pleased to announce that I’ll be presenting on BIML for the Columbus SQL Server User Group on December 11th at the Microsoft Polaris office in Westerville, OH. If you’re located in or around the central OH area, please consider joining us! Here is...
30 0 /
prashanthjayaram
Follow /24 Nov 2014 at 4:43pm / SQL Server

Capturing DB Usage stats – sp_spaceused simulation using DMV’s.

SP_SPACEUSED sp_spaceused is one of the system stored procedure used frequently by many dba’s that reveals amount of space used by database/tables. This procedure can be executed either by passing parameters or no parameters. The objective of this stored...
86 0 /
Jason Strate
Follow /24 Nov 2014 at 4:00pm / SQL Server

Last Weeks Top “Reading” Links #110

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” ( so exciting ), follow me on  twitter  ( @StrateSQL ).  And see these throughout the day as I tweet out links of things I find interesting...
39 0 /
Colleen Morrow
Follow /24 Nov 2014 at 3:00pm / SQL Server

Exam Prep 70-463: Just the facts, ma’am   Recently updated !

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...
38 0 /
Rohit Garg
Follow /24 Nov 2014 at 1:37pm / SQL Server

TempDB Configuration Best Practices

1. Do not change collation of TempDB from the SQL Server instance collation. 2. Do not change the TempDB database owner from sa. 3. Do not drop the TempDB database. 4. Do not drop or revoke the guest user from the database. 5. Do not change the...
49 0 /
Rohit Garg
Follow /24 Nov 2014 at 1:35pm / SQL Server

Cumulative Update – 13 for SQL Server 2012 Service Pack 1 Is Now Available !

The 13th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 13 contains all the hotfixes released since the initial release of SQL Server 2012 SP1. Those who are...
34 0 /
Rohit Garg
Follow /24 Nov 2014 at 1:35pm / SQL Server

Cumulative Update – 3 for SQL Server 2012 Service Pack 2 Is Now Available !

The 3rdcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2012 SP2. Those who are facing...
34 0 /
Kevin Kline
Follow /24 Nov 2014 at 1:00pm / SQL Server

DBTA – Mission Critical Performance Enhancements in SQL Server 2014

Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.”  Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also...
41 0 /
sqlkris
Follow /24 Nov 2014 at 1:00pm / SQL Server

How Do I combine results from more than one table?

All the examples for this lesson are based on Microsoft SQL Server Management Studio and the AdventureWorks2012 database.  You can get started using these free tools using my Guide  Getting Started Using SQL Server . What are the ways I can combine...
36 0 /
Kenneth Fisher
Follow /24 Nov 2014 at 1:00pm / SQL Server

Putting sp_ at the beginning of your stored procedure.

Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So what does that do and why should we care? The primary effect is that if you put a stored procedure starting with sp_ in master you can call it...
40 0 /
SQLDBAWithABeard
Follow /24 Nov 2014 at 10:43am / SQL Server

A look at the SQL Assessment Intelligence Pack in Operational Insights

Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate and visualize all your machine data in one place. It can collect data from all of your machines either via SCOM or by using an agent...
39 0 /
Kevin Kline
Follow /21 Nov 2014 at 5:08pm / SQL Server

Put Your New Leadership Knowledge Into Practice

Have you ever tried to hit a golf ball toward the pin, toss a dart at the bull’s-eye, or chuck a fly at a trout? If you’re like most people, your first attempt didn’t come anywhere close to hitting the mark. Your golf ball may have found...
31 0 /
Jason Strate
Follow /21 Nov 2014 at 4:00pm / SQL Server

Reblog: November 14 to November 20

Photo credit – JStove Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no...
105 0 /
WaterOx
Follow /21 Nov 2014 at 3:00pm / SQL Server

Have We Devalued SQL Server Consulting?

Have we given too much away? SQL Server has an amazing community. It freely provides information and training of SQL Server technologies via the internet and even in person events like SQL Saturday’s. Has the value of SQL Server Consulting Diminished...
141 0 /