SQL Server

SQL Server Community

SQL Server Blogs

Jen McCown
Follow /20 Oct 2014 at 6:12pm / SQL Server

Minion Reindex arrives this Friday!

The MidnightDBA team is announcing the release of a new, free index maintenance solution for SQL Server: Minion Reindex by MidnightDBA.  We designed Minion Reindex to solve all of the reindexing headaches we’ve experienced at dozens and dozens of client...
80 0 /
Stuart Ainsworth
Follow /20 Oct 2014 at 2:10pm / SQL Server

#SQLPASS–Who’s Making It Rain?

  As promised in my previous post ( #SQLPASS–Good people, bad behavior… ), I’d like to start diving in to some of the controversies that have cropped up in the last year and critically analyze what I consider to be “bad decisions”.  This...
44 0 /
Rohit Garg
Follow /20 Oct 2014 at 1:56pm / SQL Server

Add Database File on Database invloved in DB Mirroring

Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically. Steps to Add Database File on Database...
23 0 /
Kenneth Fisher
Follow /20 Oct 2014 at 1:00pm / SQL Server

Update to “The clustered index columns are in all of the non clustered indexes.”

I certainly hadn’t planned on creating a part two of this post but in the comments Jeremy Hughes pointed out that my understanding was if not incorrect, incomplete. So I did some additional testing, confirmed a few things with Paul Randal ( b /...
23 0 /
Jen Stirrup
Follow /20 Oct 2014 at 11:38am / SQL Server

Future Decoded – I’m speaking on machine Learning

I’m speaking at Future Decoded, at the same event as Professor Brian Cox , Sir Nigel Shadbolt (Co-founder & Chairman, ODI Open Data Institute), Or Arbel, (CEO, Yo), Michael Taylor (IT Director, Lotus F1 Team), Kenji Takeda, Microsoft Research...
23 0 /
Chris Webb
Follow /19 Oct 2014 at 11:37pm / SQL Server

Sentiment Analysis In Excel With Azure Machine Learning And Power Query

You may have seen Joseph Sirosh’s blog post last week about the ability to publish Azure Machine Learning models to the Azure Marketplace, and that MS have published a number of APIs there already. There’s a new Excel add-in that can be used with these...
54 0 /
Larry Leonard
Follow /17 Oct 2014 at 6:53pm / SQL Server

Script to Create Multiple, Same-Sized Tempdb Files

This script will take a tempdb database with one database file, and create a set of equally-sized files. You can set how much total space you want the files to use, and how many files to have (in total). From BOL, as a general guideline, create one data...
76 0 /
Jason Strate
Follow /17 Oct 2014 at 5:00pm / SQL Server

Reblog: October 10 to October 16

Photo credit – JStove Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no...
63 0 /
WaterOx
Follow /17 Oct 2014 at 3:00pm / SQL Server

Untrusted Foreign Keys

What is a Foreign Key? Do you trust your foreign keys? A foreign key is a link between 2 tables that is used to enforce referential integrity in the database. For example, if you have an order and a customer table, there is probably a logical relationship...
64 0 /
Tracy McKibben
Follow /17 Oct 2014 at 1:00pm / SQL Server

Friday Followup For October 17, 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 Invite for #TSQL2sday #59 – My Hero! Using...
57 0 /
James Serra
Follow /16 Oct 2014 at 4:00pm / SQL Server

Analytics Platform System (APS) AU2 released

The Analytics Platform System (APS) , which is a renaming of the Parallel Data Warehouse (PDW) , has recently released an appliance update (AU2), which is sort of like a service pack, except that it includes many new features.  These appliance updates...
80 0 /
David Dye
Follow /16 Oct 2014 at 2:29pm / SQL Server

IDENTITY Crisis

I was recently presented with the task of examining a database, from historic backups, to determine transactions applied over the past 6 years.  Unfortunately, the only background/source data available was a few weeks of full backups and, to make this...
55 0 /
Kenneth Fisher
Follow /16 Oct 2014 at 1:00pm / SQL Server

UNION vs UNION ALL

You might be wondering why I’m going into such a simple subject. Well the way I see it there are four options here. You already know the difference, it seems really obvious and you are probably wondering why I’m mentioning it. You think...
73 0 /
Derik Hammer
Follow /16 Oct 2014 at 1:00pm / SQL Server

Dynamically create table results from non-query

Have you ever executed a command with a result set but you didn’t know the exact schema being returned? Have you ever wanted to create a temporary table from a query but don’t want to look up all of the column data types? Of course you have...
112 0 /
Melissa Coates
Follow /16 Oct 2014 at 2:01am / SQL Server

Signing Into SSMS 2014 as Domain User on Non-Domain Computer

Overview: Just a quick tip about one way to run an application, such as SQL Server Management Studio, under the context of a domain user if you're not on a domain computer. Last week I started a new client engagement and we were tackling connectivity...
118 0 /