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

Archives: October 2014

Session: Introduction to Powershell Cmdlets for DBAs

I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged about it! Download the session recording here Download the code file here Abstract: You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell.…

Read more

1 comments, 799 reads

Posted in SQL Awesomesauce on 28 October 2014

Minion Reindex is here

We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite literally thrilled. Webinar Today! Before I get to anything else: set up an alert for our Minion Reindex Intro Webinar TODAY (Monday, October 27, 2014)…

Read more

1 comments, 651 reads

Posted in SQL Awesomesauce on 27 October 2014

Minion Reindex arrives this Friday!

Edit: Minion Reindex has arrived, and it’s getting fantastic notes! 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…

Read more

0 comments, 1,005 reads

Posted in SQL Awesomesauce on 20 October 2014

PASS Summit 2014: Recommendations and Invitations (#sqlpass #Summit14)

The first week of November, we’ll be at the PASS Summit inSeattle, WA.  This is the highlight of most SQL Server speakers’ years…a sort of educational, Christmassy nerdfest, with a feel of a class reunion mixed in. We have a lot of fun, and so I’d like to draw your…

Read more

1 comments, 594 reads

Posted in SQL Awesomesauce on 10 October 2014

Tip: Concatenate rows with XML, or COALESCE

Edit: I went and changed the first query without paying close enough attention. I’ve fixed the explanation and the query. Concatenate rows with XML I still reference my Forgotten T-SQL Cheat Sheet, especially for the XML trick that turns a set of rows into a list. The T-SQL Cheat Sheet…

Read more

4 comments, 755 reads

Posted in SQL Awesomesauce on 8 October 2014