SQL Server

SQL Server Community

SQL Server Blogs

Chris Webb
Follow /24 Apr 2015 at 11:02am / SQL Server

Analysing SSAS Extended Event Data With Power Query: Part 2, Storage Engine Activity

In part 1 of this series I showed how to use Power Query to extract Extended Event data generated by SSAS. Having done that, I now want to show the first (I hope of many) examples of how this data can be used for performance tuning: analysing activity...
64 0 /
Rohit Garg
Follow /24 Apr 2015 at 6:49am / SQL Server

Window Server 2008 Failover Clustering Logs

In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%\Cluster folder on each node in the cluster and the name of the file is CLUSTER...
72 0 /
Derik Hammer
Follow /23 Apr 2015 at 3:38pm / SQL Server

PowerShell Start-Job

The Start-Job Cmdlet is a fast and extremely simple means of spawning asynchronous threads. Why do we care? Because performing parallel work is faster and our time is important. If I want to inventory the Windows services running on every server in my...
126 0 /
WaterOx
Follow /22 Apr 2015 at 3:30pm / SQL Server

How Many SQL Log Files Do You Keep?

Reading Time: 2 minutes Ever have this happen? You (on vacation): I’ll have another piña colada please. Yes, in the coconut. Thanks! Hmm, my phone is ringing…..Hello? Work: There are problems! The database is messing up and being really...
134 0 /
sqlkris
Follow /22 Apr 2015 at 2:00pm / SQL Server

How to Write Queries – Formulate your Question – Step 2

This is the third 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...
115 0 /
Kenneth Fisher
Follow /22 Apr 2015 at 1:00pm / SQL Server

Backup before you restore

You should always be recoverable. If you haven’t heard that before, take note of it. It’s important. A while back I wrote about Operational Recovery . This is when there isn’t a disaster but you still need to restore some or all of...
89 0 /
Chris Webb
Follow /22 Apr 2015 at 4:15am / SQL Server

Power Query Announcements At The PASS BA Conference

There were a couple of big (well, big if you’re a Power Query fan like me) announcements made today by Miguel Llopis at the PASS BA Conference: Today Power Query is available only to people who have Excel Professional Plus or Excel standalone, but...
147 0 /
Ed Elliott
Follow /21 Apr 2015 at 10:28pm / SQL Server

What Permissions do I need to generate a deploy script with SSDT?

It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you may not want to give the user or process that does this sysadmin permissions just so that it can...
91 0 /
sqlsanctum
Follow /21 Apr 2015 at 3:00pm / SQL Server

Monitoring Backup and Restore Times

Backups and restores are arguably the most important aspect of a DBA’s job. There are few times when a manager will be breathing down your neck more impatiently than during a restore process. Of course, one of the worst things you can say during such...
95 0 /
Gethyn Ellis
Follow /21 Apr 2015 at 12:00pm / SQL Server

SQL 2014 CU5

By David Postlethwaite If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited GUI support for SQL Azure databases. Right click gives you very few options and there’s no designer for tables, views or logins. You will have...
108 0 /
DBAFromTheCold
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...
105 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...
132 0 /
regbac
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...
110 0 /
derekewilson
Follow /20 Apr 2015 at 1:00pm / SQL Server

T-SQL HOST_ID and HOST_NAME

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...
120 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...
108 0 /