SQL Server

SQL Server Community

SQL Server Blogs

Melissa Coates
Follow /10 Jul 2014 at 3:49pm / SQL Server

How to Interact with a PivotTable in Power BI for Office 365

Being able to make a few quick changes to a PivotTable in the browser, without having to download the workbook, is a great feature. Initially when you view an Excel workbook in Power BI (and by this I mean in Office 365 via the browser rather than the...
15 0 /
Kenneth Fisher
Follow /10 Jul 2014 at 1:00pm / SQL Server

db_ddladmin and the SSMS table designer

If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you have a several options. For example: You can grant all of the CREATE permissions either to the database itself or to all of the schemas. ...
27 0 /
Tom LaRock
Follow /10 Jul 2014 at 2:33am / SQL Server

VM Snapshots and Performance or: How I Learned to Love My Martian Data Center

It takes a radio signal just  about 1.28 seconds to get to the Moon (about 239,000 miles away), and about 2.5 seconds for round trip communication between our secret moon base and Earth. So, therefore this common SQL Server error message number 833…...
40 0 /
SQLDBAPros
Follow /8 Jul 2014 at 7:04pm / SQL Server

Tips Tuesday: Compression and Dedup

We all know one surefire way to avoid a SQL Server disaster is to be diligent about backups. Though, there is plenty of room for improvement when it comes to backup processes, especially since a typical backup on a standard SQL Server database puts a...
130 0 /
Jason Brimhall
Follow /8 Jul 2014 at 6:36pm / SQL Server

Is your Team Willing to Take Control?

The calendar tells us that once again we have reached the second tuesday of the month.  In the SQL Community, this means a little party as many of you may already know.  This is the TSQL Tuesday Party. This month represents the 56th installment of this...
54 0 /
Shaun Stuart
Follow /8 Jul 2014 at 4:49pm / SQL Server

SQL 2012 SP2 Quality Of Life Improvement

With the release of SP2 for SQL 2012, SQL Server Management Studio got a bug fix that results in a nice quality of life improvement. Since the initial release of SQL 2012, plain text in SSMS always showed up in teal, no matter what you set it to via the...
56 0 /
Kenneth Fisher
Follow /8 Jul 2014 at 1:00pm / SQL Server

T-SQL Tuesday #56: Assumptions

I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can be certain that Dev Nambi( b / t ) has decided to make Assumptions the topic of the 56th T-SQL Tuesday. I generally like to start with...
49 0 /
Jen Stirrup
Follow /8 Jul 2014 at 12:01am / SQL Server

Interested in helping SQLBits to craft the first ever SQLBits Wikipedia page?

Exciting DitBits news from the SQLBits camp today. We will be hosting a 'Wikipedia Edit-A-Thon' which will focus on gathering budding community authors, editors and reviewers together to create the first ever Wikipedia SQLBits page! I'm looking...
56 0 /
Rohit Garg
Follow /7 Jul 2014 at 10:14am / SQL Server

How to change TempDB system Database files location?

Steps to change TempDB system Database files location :- 1) Check current file location of TempDB Exec SP_helpDB TempDB You can use below query as well for file location details. SELECT name, physical_name AS CurrentLocation, state_desc FROM...
174 0 /
Chris Webb
Follow /7 Jul 2014 at 9:30am / SQL Server

Optimising MDX Calculations With The Unorder() Function

The Unorder() function is probably one of the least used functions in the whole of MDX. It exists only as a query performance hint and, since I had never up to now found a scenario where it did improve the performance of a calculation I had pretty much...
130 0 /
Jason Strate
Follow /4 Jul 2014 at 5:00pm / SQL Server

Reblog: June 27 to July 3

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...
79 0 /
Tracy McKibben
Follow /4 Jul 2014 at 1:00pm / SQL Server

Friday Followup For July 4, 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 Dell Webcast Followup: Subqueries For Superheroes...
69 0 /
Jason Strate
Follow /3 Jul 2014 at 5:37pm / SQL Server

Microsoft MVP 2014 – SQL Server Award

This past week, I was awarded with the Microsoft MVP 2014 for SQL Server award.  This is my sixth award in a row and I am deeply appreciative for this recognition from Microsoft.  If you aren’t familiar with the Microsoft’s MVP program , it is an...
78 0 /
prashanthjayaram
Follow /3 Jul 2014 at 4:58pm / SQL Server

PowerShell- Monitoring Group Of Services on Group of Servers with Alternate Credentials

This script will allow you to read a list of computers from the input file and use credentials to connect to remote/DMZ server to get the required service status information only specified services. This post explains how to monitor a multiple services...
72 0 /
prashanthjayaram
Follow /3 Jul 2014 at 4:58pm / SQL Server

PowerShell- Monitoring Group Of Services on Group of Servers with Alternate Credential

This post explains how to monitor a multiple services on a group of servers with alternate credentials. This script will allow you to read a list of servers from the input file and use credentials to connect remote/DMZ servers to pull service status...
72 0 /