SQL Server

SQL Server Community

SQL Server Blogs

Shaun Stuart
Follow /21 Apr 2014 at 1:00pm / SQL Server

Disabling An Index Removes Index Data

DBAs gained the ability to disable indexes in SQL Server 2005. This is a handy little option when you are tuning indexes or consolidating indexes. When you disable an index, you tell SQL Server to basically pretend the index doesn't exist. Data changes...
12 0 /
Kenneth Fisher
Follow /21 Apr 2014 at 12:00pm / SQL Server

Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out. I’ve talked...
20 0 /
Gethyn Ellis
Follow /21 Apr 2014 at 8:00am / SQL Server

Central Management Studio CMS

By David Postlethwaite At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover. One of the subjects I covered was Registered Servers and the...
18 0 /
Dinesh Asanka
Follow /21 Apr 2014 at 6:10am / SQL Server

APRIL 2014 MEET-UP

More at http://www.sqlserveruniverse.com/SSSLUG.aspx http://dbfriend.blogspot.com/feeds/posts/default?alt=rss
19 0 /
Chris Webb
Follow /19 Apr 2014 at 8:00am / SQL Server

Web Services And POST Requests In Power Query

In my recent post on web services in Power Query I mentioned that while the Power Query Web.Contents() function generates a GET request by default, you can make it generate a POST request by specifying the Content option. Since this is a useful thing...
49 0 /
Jason Strate
Follow /18 Apr 2014 at 4:00pm / SQL Server

Reblog: April 11 to April 17

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...
38 0 /
Tracy McKibben
Follow /18 Apr 2014 at 12:00pm / SQL Server

Friday Followup For April 18, 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 Why So Serious? – #TSQL2sDAY #53 Do You Need...
43 0 /
Dinesh Asanka
Follow /18 Apr 2014 at 3:50am / SQL Server

By the Numbers: The VAR - Big Data Market Opportunity

If you've been following the trends, you already know that Big Data can be very good for your business . But do you know just how good it can be? Let's take a look at some numbers, courtesy of the analysts. Read more at here http://dbfriend.blogspot...
58 0 /
James Serra
Follow /17 Apr 2014 at 5:36pm / SQL Server

What is the Microsoft Analytics Platform System (APS)?

Analytics Platform System (APS) is simply a renaming of the Parallel Data Warehouse (PDW).   It is not really a new product, but rather a name change due to a new feature in Appliance Update 1 (AU1) of PDW.  That new feature is the ability to have a HDInsigh...
72 0 /
David Dye
Follow /17 Apr 2014 at 5:06pm / SQL Server

SQL Saturday Puerto Rico 2014

WHAT AN AWESOME EVENT!! I want to thank everyone for such an incredible experience and special thanks to Jose Rivera, Guillermo Caicedo and all the volunteers for all of your work. Can’t wait for next year! As promised my presentation materials can...
42 0 /
SQLDBAPros
Follow /17 Apr 2014 at 12:56pm / SQL Server

Hey Native Tools – What Have You Done for Me Lately?

When it comes to backup and recovery, industry veterans know that for years Microsoft has provided a very capable, out-of-the-box tool, already built into SQL Server. However, these same veterans have also figured out that with this solution, comes limitations...
174 0 /
Gethyn Ellis
Follow /17 Apr 2014 at 8:00am / SQL Server

SSMS Auto Recovery

By David Postlethwaite At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on Gethyn’s blog about the bits I didn’t manage to cover. SQL Server Management Studio will autosave your unsaved query...
64 0 /
Jen Stirrup
Follow /17 Apr 2014 at 8:00am / SQL Server

Why I refused a session at SQLBits; it's not about your rank, but your legacy

In martial arts it is not your belt rank that matters but the legacy you leave.” – Grandmaster CK Leow, Founder, Moodukkwan Malaysia I've attended every SQLBits except two: the first one, because I didn't know about it, and SQLBits 6, because...
61 0 /
Tom LaRock
Follow /17 Apr 2014 at 1:00am / SQL Server

You’re Doing It Wrong – Database Standards

Having standards is important. If you don’t believe me, just ask your spouse or significant other. Knowing that such things are important I am willing to wager that your company has spent time putting together a set of standards to be followed with...
67 0 /
Kenneth Fisher
Follow /16 Apr 2014 at 12:00pm / SQL Server

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions which lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes...
73 0 /