SQL Server

SQL Server Community

SQL Server Blogs

Jen Stirrup
Follow /20 Oct 2014 at 10: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...
6 0 /
Chris Webb
Follow /19 Oct 2014 at 10: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...
34 0 /
Larry Leonard
Follow /17 Oct 2014 at 5: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...
62 0 /
Jason Strate
Follow /17 Oct 2014 at 4: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...
51 0 /
Follow /17 Oct 2014 at 2: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...
57 0 /
Tracy McKibben
Follow /17 Oct 2014 at 12: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...
48 0 /
James Serra
Follow /16 Oct 2014 at 3: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...
72 0 /
David Dye
Follow /16 Oct 2014 at 1:29pm / SQL Server


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...
47 0 /
Kenneth Fisher
Follow /16 Oct 2014 at 12:00pm / SQL Server


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...
66 0 /
Derik Hammer
Follow /16 Oct 2014 at 12: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...
100 0 /
Melissa Coates
Follow /16 Oct 2014 at 1: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...
111 0 /
Chris Shaw
Follow /15 Oct 2014 at 3:50pm / SQL Server

SQL Server Buffer Extensions

Have you ever noticed when you are working on a query for SQL Server and the second time you execute the query it runs much faster than the first time you had executed it? There is a reason for this and most likely it is caused by your buffer. When...
130 0 /
Follow /15 Oct 2014 at 9:20am / SQL Server

Tracking down CPU spikes using process explorer and DMVs

What is it about 4:45 pm on a Friday afternoon that makes CPUs spike, drives crash, databases corrupt? I wish I knew but I don’t. I do know that I have been on the receiving end a few times. Just shutting down the last applications when a call or...
130 0 /
Jason Brimhall
Follow /14 Oct 2014 at 8:18pm / SQL Server

Murder In Utah

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops  here . ...
88 0 /
Follow /14 Oct 2014 at 5:10pm / SQL Server

T-SQL – Scripting Stored Procedure to Create backup copy on same database

This post is one of the request from OP. Download the SQL   Backup SP in the same database The probelm statement 1:- Create a backup copy of a group of stored procedures on the same database.  Using TSQL I need to find all stored procedures that...
77 0 /