SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: July 2015

Executing SELECT query using TOP without ORDER BY

Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY, and not realising that the query could end up returning random results. We will look at this in a bit of details with some examples.

Assuming you are able to… Read more

0 comments, 6,308 reads

Posted in SQLYSE with Pankaj Manek on 31 July 2015

014 -Kon Melamud - WaterOx Consulting

Kon!!!!!! In WOxPod!, episode # 014 – “Kon Melamud” Today we have...

The post 014 -Kon Melamud appeared first on WaterOx Consulting.

Read more

0 comments, 1,119 reads

Posted in WaterOx SQL on 31 July 2015

SQL Server Infernals – Circle 6: Environment Pollutors

Don’t tell me that you didn’t see it coming: at some point, Developers end up being put to hell by a DBA!

I don’t want to enter the DBA/Developer wars, but some sins committed by Developers really deserve a ticket to the SQL Server hell. In particular, some of those… Read more

2 comments, 1,192 reads

Posted in SpaghettiDBA on 31 July 2015

Migration of a large enterprise from SQL Server 2000 to 2014. Real life case.

This is a first article in a series of articles about real life database and IT infrastructure migration project which has been executed for a large US company which services are heavily dependent on fast and reliable database infrastructure. In this article we`ll give a brief description of the project,… Read more

0 comments, 2,579 reads

Posted in Forrards Group Database Blog on 31 July 2015

Whats new in SQL Server 2016

While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with great new advance features and stable SQL Server(just like after 2005 to SQL Server 2008). To learn more about SQL … Continue reading

Read more

0 comments, 1,593 reads

Posted in Vinay Thakur on 31 July 2015

Three Best Practices for #PowerBI

Since the release of Power BI Desktop this past week, I’ve been really spending my extra time digging into the application focusing on learning and experimenting as much as I can. When my wife has been watching Law and Order: SVU reruns at night after the rug rats are in… Read more

2 comments, 1,157 reads

Posted in SQL with Dustin Ryan on 31 July 2015

SQLSaturday Dallas Precons Community Choice

The North Texas SQL Server User Group Board of Directors has decided to do something a little bit different for selecting Precons for our next SQLSaturday.  The SQLSaturday event will be held on October 3rd with the precons on October 2nd.  We have decided that since it is the community… Read more

10 comments, 1,053 reads

Posted in Ryan Adams on 30 July 2015

Planning and Configuring Distributed Cache Service || Part 2

Hi All,

As per the previous article, i have tried to create the understanding for Distributed Cache service : Understanding, Planning and Configuring Distributed Cache Service

In this current article will try to see with the planning and configuration of the DCS.

Planning & Capacity analysis of Distributed Cache Service:

Read more

1 comments, 1,212 reads

Posted in AshishSharePointBlog on 30 July 2015

Addicted To Busy

Our world is made up of technology and being plugged in 24/7. As you walk down the street you may notice on either side of the sidewalk people walking and looking at their phone. Texting, emailing, social media, and the like is all the buzz. I fall victim to this… Read more

2 comments, 1,003 reads

Posted in The SQL Professor on 30 July 2015

Addicted To Busy

Our world is made up of technology and being plugged in 24/7. As you walk down the street you may notice on either side of the sidewalk people walking and looking at their phone. Texting, emailing, social media, and the like is all the buzz. I fall victim to this… Read more

2 comments, 690 reads

Posted in The SQL Professor on 30 July 2015

Professional Development – What a Difference 60 Years Makes

Originally appearing at ForITPros.com.

In 1957, the Soviet-made Sputnik streaked across the sky in low earth orbit. It was clearly visible to millions of concerned Americans. The Soviet government had leapfrogged America technologically. The dot that traversed the nighttime sky marked a change in international politics and fueled the… Read more

0 comments, 1,021 reads

Posted in Kevin E. Kline on 30 July 2015

Reblog: The shaky bug in SSIS

SQLKover update: I’m reblogging this a bit earlier (it’s a quite recent blog post) because I still see people with this issue. Also, it seems that sometimes the fix doesn’t work.

You may or may not have noticed it after installing SQL Server 2012/2014: the designer interface in Visual Studio… Read more

0 comments, 999 reads

Posted in Koen Verbeeck on 30 July 2015

List Out All the SQL servers In domain


In One Of the Group the question was asked that How to list all the Servers in which SQL is installed?

It is genuine query. There are many scenario when you need to Find out how much SQL servers are there in the domain ? many a times… Read more

0 comments, 10,660 reads

Posted in SQLSERVERSdba on 30 July 2015

Internal Tables and Space Used

Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little bit of diving into the internals to figure out what is happening or even why it is complex.

I enjoy the… Read more

0 comments, 1,364 reads

Posted in SQL RNNR on 30 July 2015

Power BI v2 is GA

I guess in the age of rapid development and releases the fact of General Availability of the Power BI v 2.0 on the last friday, 24th of July 2015 was something that anyone somehow connected to the world of Business Intelligence could have missed.
Even though so many Microsoft Data… Read more

0 comments, 1,031 reads

Posted in Niko's blog on 29 July 2015

Hey Kids! Let’s Put on a Show at the Old Barn

Alternate Title: I’m traveling a bunch. Let’s get together and talk.

A bunch of trips and presentations coming up, so I thought I’d share. First, I’ll be SQL Saturday Omaha for my first time ever presenting in Nebraska. I’m excited to add this state to my list (which is almost… Read more

1 comments, 940 reads

Posted in The Scary DBA on 29 July 2015

Halloween at PASS–Donate for some fun

This year’s PASS Summit will end on Oct 30, which is just before Halloween in the US. I’m sure lots of people will have some fun on Friday, though I also suspect we’ll see no shortage of people leaving early to get home to spend the holiday with families.

A… Read more

1 comments, 1,884 reads

Posted in The Voice of the DBA on 29 July 2015

DBTA – IT Employers Must Adapt to the Looming DBA Shortage

Originally appearing in my monthly column at Database Trends & Applications magazine.

In the first of this three-part series, I described some of the findings contained in an intriguing new survey published by Unisphere Research, a division of Information Today, Inc. In that article, I covered the macroeconomic and… Read more

4 comments, 1,070 reads

Posted in Kevin E. Kline on 29 July 2015

Some of my favorite SSMS Keyboard shortcuts

I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of my other favorites.

  • Shft+Arrow keys (sometimes + Ctrl): Highlight blocks of code. Adding in the control key moves you a word at a time rather than a single character.…

Read more

10 comments, 1,230 reads

Posted in SQLStudies on 29 July 2015

Synchronous Processing in the SSIS Script Component

Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component.  This control grants ETL developers complete control over the flow of data, leverages the full power of the .NET Framework namespaces, and can be used as a source, destination, or transformation in data… Read more

0 comments, 2,702 reads

Posted in Tim Mitchell on 29 July 2015

Older posts