SQL Server

SQL Server Community

SQL Server Blogs

Rohit Garg
Follow /22 Dec 2014 at 4:14am / SQL Server

Use of RPC in Cluster

Today, My one of friend come back from SQL DBA interview & share his review. One question about which he is looking for was “What is the use of RPC in cluster” ? The Remote Procedure Call (RPC) [http://support.microsoft.com/kb/832017] system service...
13 0 /
Melissa Coates
Follow /20 Dec 2014 at 10:14pm / SQL Server

Big Changes - What You Need to Know About the Power BI Public Preview

Yesterday Microsoft released a Public Power BI Preview for customers to evaluate new features in Power BI. This newly redesigned platform offers many familiar components, as well as some new and unique features. Which means you may be asking yourself...
41 0 /
Paul Turley
Follow /20 Dec 2014 at 9:52pm / SQL Server

New Power BI stand-alone Designer, Dashboards, APIs & iOS App

This week Microsoft announced the availability of Power BI Dashboards and the browser-based dashboard designer.  What is it and why is it important?  The most significant thing about it is that report and dashboard users do not need to have...
257 0 /
Kevin Kline
Follow /19 Dec 2014 at 5:27pm / SQL Server

First Ask “Why”, then Ask “How”

A common refrain we hear when presenting at technical conferences and training events is “How can I get promoted into IT management?” We hear this so often that we’ve worked out a sort of mental flowchart for the subsequent dialog. (We are IT people after...
44 0 /
Tim Radney
Follow /19 Dec 2014 at 4:07pm / SQL Server

I am joining SQLskills

I am no longer just a SQLskills Insider, I am now a SQLskills employee. I have accepted an offer to join an incredible team of SQL Server professionals and continue growing in my SQL career.  I am very excited to be working with some of the best in the...
56 0 /
Jason Strate
Follow /19 Dec 2014 at 4:00pm / SQL Server

Reblog: December 12 to December 18

Photo credit – Travis Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time to dig out some old posts and find out if there are any undiscovered finds there. In this post, I’m bringing...
52 0 /
Arthur Olcot
Follow /19 Dec 2014 at 1:38pm / SQL Server

XQuery – Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the “attribute” axis even if you don’t know or need to know the attribute names. By using this axis you can access all of the attributes within the given...
44 0 /
Tracy McKibben
Follow /19 Dec 2014 at 1:00pm / SQL Server

Friday Followup For December 19, 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 sp_BackupDatabases v1.3 Cheating DBCC To Fix Index...
57 0 /
Gethyn Ellis
Follow /19 Dec 2014 at 10:58am / SQL Server

Offer – Any e-book for $5

Packt Publishing are having a price drop bonanza over the Christmas period. You can get any e-book for just $5 (£3.60 in British money). This includes my book, Getting Started with SQL Server 2012 Administration The offer will run from Thursday 18th Dec...
54 0 /
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...
122 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...
124 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...
110 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...
150 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...
69 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...
65 0 /