SQL Server

SQL Server Community

SQL Server Blogs

Dinesh Asanka
Follow /19 Dec 2014 at 5:08am / SQL Server

SQL Server 2014 – Delayed Transaction Durability

Prior to SQL Server 2014, SQL Server used a Write Ahead Log (WAL) mechanism which means that changes are written to the transaction log before they are committed. The major advantage with this mechanism is that there will be no data loss . However, since...
30 0 /
Shaun Stuart
Follow /18 Dec 2014 at 4:00pm / SQL Server

Using PowerShell For More Readable Log Files

Most of the scheduled jobs on my SQL Servers write some sort of output to a log file. Most of the time, it's just the output of a SQL statement. However, for some of my longer, more complicated routines, the procedures I write include PRINT statements...
78 0 /
James Serra
Follow /17 Dec 2014 at 4:00pm / SQL Server

Analytics Platform System (APS) AU3 released

The Analytics Platform System (APS) , which is a renaming of the Parallel Data Warehouse (PDW) , has just released an appliance update (AU3), which is sort of like a service pack, except that it includes many new features.  These appliance updates are...
85 0 /
John Sterrett
Follow /17 Dec 2014 at 3:09pm / SQL Server

Building Your First Windows Azure Machine

Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted out on SQLAuthority.com . This tip was my first one working with Azure.  To me its remarkable how quickly you can spin up an instance...
121 0 /
Derik Hammer
Follow /17 Dec 2014 at 2:00pm / SQL Server

My Epic Life Quest – Level 2 Achieved

DING – LEVEL 2 !!! I am excited to announce that I have achieved level 2 in My Epic Life Quest . My epic life quest is an idea that I got from Steve Kamb via Brent Ozar. As life goals are achieved you gain experience and after 5 achievements...
44 0 /
Kenneth Fisher
Follow /17 Dec 2014 at 1:00pm / SQL Server

Playing with the log – VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of VLFs (virtual log files). These VLFs are a logical way for SQL to break the physical file down into smaller pieces. These pieces are then marked as “in...
42 0 /
Melissa Coates
Follow /17 Dec 2014 at 12:01pm / SQL Server

Power Pivot Update and Issue with Relationships Between Tables

Yesterday the Power BI team released a fantastic new update that improves the usability of Power Pivot inside of Excel. I'm thrilled with what I've seen so far as it removes a lot of the delays when making changes to the data model. However.....
71 0 /
Chris Webb
Follow /16 Dec 2014 at 10:17pm / SQL Server

Bing Pulse

A recent post on the Bing blog alerted me to a Microsoft service called Bing Pulse that I hadn’t heard about before. It’s a way of collecting and analysing audience feedback in real time during events like TV programmes, sporting events and speeches;...
48 0 /
Kenneth Fisher
Follow /16 Dec 2014 at 10:03pm / SQL Server

‘Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office not a creature was stirring, not even the bosses. The code was checked in, into Tortoise with care, in hopes a release date – soon would be there. The devs were all slumped – in front...
48 0 /
sqlkris
Follow /16 Dec 2014 at 1:00pm / SQL Server

Interview with Jack Vamvas

I recently had the opportunity to interview Jack Vamvas about SQL, Optimization, and being a DBA. This interview is sprinkled with many gems of practical advice.  1. What is some advice you would give someone that wanted to become a DBA? Learn...
84 0 /
derekewilson
Follow /16 Dec 2014 at 12:08pm / SQL Server

ROW_NUMBER SQL Server

Row_Number SQL Server SQL Server includes several Ranking Functions that can be called in T-SQL.  One of these is the Row_Number() function.  You can use this function to return a sequential number in your result set that begins at 1. There are 2...
59 0 /
Jen McCown
Follow /15 Dec 2014 at 2:29pm / SQL Server

Create a clustered index and a primary key on existing tables

It’s the simple things in life that can trip people up. I find that creating primary keys and clustered indexes on existing tables is one that newish DBAs tend to trip up on, and so (like I do), I shall blog about it so there’s a nice, clear...
115 0 /
Tracy McKibben
Follow /15 Dec 2014 at 1:00pm / SQL Server

The Value of Writing Good

Most of my peers, and likely yours as well, work in some sort of technical field. Odds are that they’re proficient readers who can digest the driest of technical material. They’re probably good with math, and a large portion of them are likely science...
137 0 /
Kevin Kline
Follow /15 Dec 2014 at 1:00pm / SQL Server

DBTA – Microsoft SQL Server and the Big Data Play

When it comes to implementing a big data strategy in a Microsoft SQL Server shop, you’re generally going to consider one of three strategies. In the first strategy, which I won’t be addressing today, you might choose to tackle your big data architecture...
134 0 /
Kenneth Fisher
Follow /15 Dec 2014 at 1:00pm / SQL Server

Does a clustered index sort the rows within a page

This is just something I was curious about. I ran my tests and got an answer and now I thought I would share. Before I start I want to point out a few things about my tests. I’m using code to create/modify a PRIMARY KEY. PRIMARY KEYs are not necessarily...
62 0 /