SQL Server

SQL Server Community

SQL Server Blogs

Thomas LaRock
Follow /24 Dec 2014 at 7:06pm / SQL Server

5 Ways To Avoid Having To Write a Christmas Blog Post

Yes, it’s that time of year again, when every blogger takes time out of the schedule to produce a post about Christmas or whatever Happy Holiday you celebrate. Truth be told I spent the past two weeks trying to think of something I could write about...
25 0 /
Derik Hammer
Follow /24 Dec 2014 at 2:00pm / SQL Server

Failing over AlwaysOn Availability Groups

Merry Christmas Eve! A few weeks ago I posted on Availability Group fail-over tests with PowerShell . That post covered the basics of how to check the Availability Group’s state and perform the commands for conducting a zero data loss fail over...
35 0 /
prashanthjayaram
Follow /23 Dec 2014 at 9:20pm / SQL Server

SQL – How to Find Missing Sequence in a table

Problem statement:-  A  table with identity column have ‘n’ rows  in that few rows are deleted. How to find  which rows are deleted? Solution:- create table test (a int); insert into test values (7001); insert into test values (7002...
47 0 /
Thomas LaRock
Follow /23 Dec 2014 at 8:49pm / SQL Server

How To Better Break Down Information Silos

It all started with a simple question. “What’s a table?,” my nine-year-old daughter asked me during a session I was giving at SQL Saturday #184 last year. Now, being my daughter, I know that she has the innate ability to ask questions just for the sake...
49 0 /
sqlkris
Follow /23 Dec 2014 at 1:00pm / SQL Server

What is the Difference between Truncate and Delete in SQL Server?

In SQL Server there are a couple a ways you can delete rows from a table.   You can use either the TRUNCATE or DELETE command.  Though the end result of both commands is the same, there are very important differences you should know about. The TRUNCATE...
48 0 /
SQLDBAWithABeard
Follow /23 Dec 2014 at 12:04pm / SQL Server

Twas 2 Days Before Xmas or Thank you SQLFamily

Twas 2 days before Xmas & all through the office, not a creature was stirring not even old Maurice. With merriment going on outside of his window There sat a bearded DBA without much to do No changes can be made through the holiday season We...
154 0 /
Chris Yates
Follow /22 Dec 2014 at 5:49pm / SQL Server

Blink – Year is gone

As the door begins to knock I start to wonder who it can be. As I begin to open it the person on the other side asks if he can talk to Perfection. No, I replied, perfection isn’t here and will never be here. That same concept is what this blog...
37 0 /
Chris Webb
Follow /22 Dec 2014 at 3:00pm / SQL Server

Viewing Error Messages For All Rows In Power Query

One of the great features of Power Query is the way you can view any rows that contain error values when you load data. However, even if you can see the rows that have errors you can’t see the error messages easily – without writing a little bit of M...
55 0 /
Kevin Kline
Follow /22 Dec 2014 at 1:00pm / SQL Server

DBTA – Big Data and Microsoft SQL Server HDInsight

It’s time to follow up with a discussion of Microsoft’s cloud-centric approach to big data using HDInsight. MICROSOFT SQL SERVER AND BIG DATA IN THE CLOUD HDInsight is a 100% Apache Hadoop service, currently at v2.2, available through Microsoft’s...
111 0 /
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...
60 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...
68 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...
702 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...
71 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...
89 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...
128 0 /