SQL Server

SQL Server Community

SQL Server Blogs

Stuart Ainsworth
Follow /23 Oct 2014 at 1:02pm / SQL Server

#SQLPASS – Fluffy Bunnies

I didn’t really have a good name for this post, so I thought I’d just try to pick something as non-offensive as possible.  Everybody likes bunnies, right?  Anyway, the last series of posts that I’ve made regarding the Professional Association...
36 0 /
Jason Brimhall
Follow /22 Oct 2014 at 10:16pm / SQL Server

Database Ghosts

Recently you may have seen my first article on this topic over at SQL Solutions Group.  If not, here is the link so you can read that article first before proceeding here.  This article is intended as a first of two part follow-up to that article . ...
63 0 /
Derik Hammer
Follow /22 Oct 2014 at 3:13pm / SQL Server

Backup testing with PowerShell

This week I released a two part blog series on testing your backup files and reporting on the results in an automated fashion. Many elements of PowerShell, SMO, T-SQL, and SQL Server Reporting Services are covered. Abstract Once your organization...
56 0 /
Kenneth Fisher
Follow /22 Oct 2014 at 12:00pm / SQL Server

Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures . In a similar situation to the questioner let’s say we have a Baseball team. There are teams and players. A player can...
44 0 /
Paul Turley
Follow /21 Oct 2014 at 6:01pm / SQL Server

SQL Server Upgrade Preconference at PASS Summit 2014

Please join me and my associates for an all-day SQL Server Upgrade workshop on November 3rd If you are planning an upgrade to a newer version of SQL Server, you won’t want to miss this all-day, preconference workshop. Join John Martin, Sr. Technology...
10524 0 /
Stuart Ainsworth
Follow /21 Oct 2014 at 1:00pm / SQL Server

#SQLPASS–Data Professionals?

So, in my last post, I described the financial pressures of community building; two companies benefit from building a community organization.  I’ve tried to stay away from assumptions, but I am assuming that their influence must factor into the Board...
59 0 /
Jen McCown
Follow /20 Oct 2014 at 5: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...
160 0 /
Jason Strate
Follow /20 Oct 2014 at 3:00pm / SQL Server

Last Weeks Top “Reading” Links #105

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” ( so exciting ), follow me on  twitter  ( @StrateSQL ).  And see these throughout the day as I tweet out links of things I find interesting...
43 0 /
Stuart Ainsworth
Follow /20 Oct 2014 at 1: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...
149 0 /
Rohit Garg
Follow /20 Oct 2014 at 12: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...
111 0 /
Kenneth Fisher
Follow /20 Oct 2014 at 12: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 /...
51 0 /
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...
147 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...
78 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...
97 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...
83 0 /