SQL Server

SQL Server Community

SQL Server Blogs

Kevin Kline
Follow /28 Nov 2014 at 5:09pm / SQL Server

Me and You or Me versus You

Have you ever had to deal with a manager or co-worker who made your working life uncomfortable or even miserable? That’s one of the most difficult and emotionally taxing situations for adults all over the world. Each night, after a hard day of dealing...
22 0 /
Jason Strate
Follow /28 Nov 2014 at 4:00pm / SQL Server

Reblog: November 21 to November 27

Photo credit – Jenn and Tony Bot Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s...
21 0 /
Kevin Kline
Follow /28 Nov 2014 at 1:31pm / SQL Server

DBTA – For #SQLFamily, It’s the Most Wonderful Time of the Year!

It’s the holiday season, a time for cheer and goodwill towards men. That got me thinking about the whole “most wonderful time of the year” tune playing in the background and how that has some special implications for the SQL Server world. Here’s a bit...
21 0 /
Tracy McKibben
Follow /28 Nov 2014 at 1:00pm / SQL Server

Friday Followup For November 28, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Using Encryption To Protect Your Data From Alien...
41 0 /
Chris Webb
Follow /27 Nov 2014 at 9:20pm / SQL Server

Specifying Allowed Values, Sample Values and Descriptions For Function Parameters In Power Query–Part 1

The other day when I was thinking about Power Query functions (as you do) it occurred to me that they would be a lot more usable if, when you invoked them, you could show your users a dropdown box for each parameter where they could choose all of the...
33 0 /
Jason Brimhall
Follow /26 Nov 2014 at 11:23pm / SQL Server

Audit Database File Size Changes

Recently I shared an article on how to track the growths and shrinks that occur within database files.  I shared that article here , you should read it before proceeding with today’s article. Near the end of that article I declared that it was...
56 0 /
Chris Shaw
Follow /26 Nov 2014 at 6:43pm / SQL Server

Finding Tables Sizes with File Group information

Sometimes managing multiple file groups and the amount of data that is in them can cause a few logistic issues. Recently I found myself needing to know what tables are in what file groups and what the sizes of those tables are. With the database the size...
51 0 /
James Serra
Follow /26 Nov 2014 at 4:00pm / SQL Server

What is Azure Data Factory?

The Azure Data Factory is a service designed to allow developers to integrate disparate data sources.  It is a platform somewhat like SSIS in the cloud to manage the data you have both on-prem and in the cloud. It provides access to on-premises data...
47 0 /
Bob Pusateri
Follow /26 Nov 2014 at 2:36pm / SQL Server

What I’m Thankful For – 2014 Edition

I’m also grateful for my grandma’s homemade gravy Back in the early days of this blog, I wrote  about what I was thankful for in response to Jason Strate’s post asking about it . Now, 4 years later,  I am hosting a redux , and your...
41 0 /
Derik Hammer
Follow /26 Nov 2014 at 2:00pm / SQL Server

Connecting to an Availability Group Listener with SQL Server Management Studio

Background When a cluster has an Availability Group installed on it, there is an optional listener which is used to manage connections through fail-over events. This listener has an IP address assigned to it and, when the Availability Group fails over...
47 0 /
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...
53 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...
47 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...
110 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...
58 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...
58 0 /