Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Cumulative Update – 12 for SQL Server 2012 Service Pack 1 Is Now Available !

The 12th cumulative update release for SQL Server 2012 Service Pack 1 is now available for download at the Microsoft Support site. Cumulative Update 12 contains all the hotfixes released since the initial release of SQL Server 2012 SP1.

Those who are facing severe issues with their environment, they can… Read more

0 comments, 18 reads

Posted in MSSQLFUN on 17 September 2014

Cumulative Update – 2 for SQL Server 2012 Service Pack 2 Is Now Available !

The 2ndcumulative update release for SQL Server 2012 Service Pack 2 is now available for download at the Microsoft Support site. Cumulative Update 2 contains all the hotfixes released since the initial release of SQL Server 2012 SP2.

Those who are facing severe issues with their environment, they can plan… Read more

0 comments, 18 reads

Posted in MSSQLFUN on 17 September 2014

SQL Server on VMware Workshop at VMware

This past week I was fortunate enough to attend a three-day special session at VMware Corporation’s corporate campus in Palo Alto, CA, specifically designed to help educate and inform SQL Server MVPs with some of the most detailed training on the convergence of the VMware ecosystem and SQL Server. This… Read more

0 comments, 57 reads

Posted in Technobabble by Klee from @kleegeek on 17 September 2014

SQLSaturday Orlando Marketing Plan-Part 43

  • I’ve got most of the messages up through Sep 27th drafted. Still need to tweak a couple, but close to done.
  • Two messages going out tomorrow, one to the registered list and one to the – wait, yes – the unregistered list, then one on Wed for a call for…

Read more

0 comments, 41 reads

Posted in SQLAndy on 16 September 2014

DevConnections 2014

It’s time for Devconnections again, and I’m back in Las Vegas for the conference. This is a great conference if you work with a variety of Microsoft technologies, or want to learn about something in addition to SQL Server. We have some great SQL Server talks, but if you want… Read more

0 comments, 82 reads

Posted in The Voice of the DBA on 16 September 2014

Performance/ Management Data Warehouse Data Collector & AlwaysOn Availability Groups

Verwaltungs-Data Warehouse Datensammler & AlwaysOn Hochverfügbarkeitsgruppen

(EN)
This time, we are dealing with the „MDW“, short for Management Data Warehouse,(msdn.microsoft.com/en-us/library/bb677306.aspx), which I like to recommend as a minimal performance logging-approach.

From time to time, and most recently in the context of my PASS Essential „SQL Server…

Read more

0 comments, 76 reads

Posted in Andreas Wolter SQL Server & BI blog (English / German) on 16 September 2014

PASS Summit 2014 Pre-Conference Seminar

I’m putting on a pre-conference seminar (also known as a pre-con) at the PASS Summit this year. I’m really honored to be able to present this and I’m pretty excited about it. So, if you want to talk query tuning, let’s get together at the Summit. For a few fun… Read more

0 comments, 71 reads

Posted in The Scary DBA on 16 September 2014

We’re On

We crossed the $10k mark for the Argenis Without Borders campaign, meaning that Brent, Grant, Adam, Gail, and myself will join Argenis in dressing up in colorful costumes at the PASS Summit. I’ve already purchased a few things, and I’m ready.

I’d like to thank everyone that donated, as… Read more

0 comments, 81 reads

Posted in The Voice of the DBA on 16 September 2014

SQL Saturday #315 - Pittsburgh

SQLSaturday is a full day FREE training event for SQL Server professionals and those wanting to learn more about SQL Server and network with the SQL Server community.
Pick from more than 30 different sessions and learn from the experts.

Don’t know anything about SQL Server? We have an entire… Read more

0 comments, 49 reads

Posted in SQL Sandwiches on 16 September 2014

Speaking at SQLSaturday #311 Bulgaria

More good news! I will be speaking on SQLSaturday #311 Bulgaria.

If you read this blog and will attend the event, come and say hi!

Read more

0 comments, 76 reads

Posted in DotNine SQL Server and more on 16 September 2014

DBA in the Cloud: Threat or Opportunity?

Five years ago the term “cloud” was still a buzzword, and there was a lot of uncertainty and misconception around it. I remember many DBAs, including myself, asking themselves what this revolution means for them. People asked themselves how a DBA role will look like in five years, or even… Read more

0 comments, 68 reads

Posted in Guy Glantser on 16 September 2014

Better Presentations–Zoom

This is part of a series of tips for speakers on how to make your presentations better.

I’ve given around 30 presentations a year for the last few years, and easily a dozen a year for a number of years before that. I visit events all over the US and… Read more

0 comments, 60 reads

Posted in The Voice of the DBA on 16 September 2014

PASS SQL Saturday Events: October 2014

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register. Please register soon as seating is limited, and let friends and colleagues know about the event. Most… Read more

0 comments, 63 reads

Posted in Marc Beacom on 15 September 2014

Outstanding PASS Volunteer

Hello Dear Reader!  In June this year I was recognized by PASS as with an Outstanding Volunteer Award.  In an unusual move I found myself speechless.  This is a very quick post to give the true credit where it is due.  June was a very busy month for me and…

Read more

0 comments, 67 reads

Posted in SQLBalls on 15 September 2014

Thoughts On the NomCom Process

We’ve just wrapped up the interviews and I wanted to jot down a few thoughts on what I’ve seen from using the process that we have today:

  • The time requirement for the NomCom members seems reasonable
  • We still have a lot of work on explaining the “why” of the tasks…

Read more

0 comments, 71 reads

Posted in SQLAndy on 15 September 2014

Podcast on Devops and the Database

I’ve been attempting to expand my reach to get back to my roots in development. I’m doing this because I really believe in the concepts behind devops, that these walls we’ve erected between development and dba, between dba and san admin, et, ad nauseum, cetera, need to come to an… Read more

0 comments, 73 reads

Posted in The Scary DBA on 15 September 2014

I SCHEMABOUND my scalar UDF and you won’t believe what happened next.

Sorry for the click bait but I just couldn’t resist, and to be fair I was pretty impressed with this little trick.

The other week I did a post on SCHEMABINDING and Diana sent me this great link on SCHEMABINDING UDFs. In it TomErv discribes SCHEMABINDING scalar UDFs that… Read more

0 comments, 92 reads

Posted in SQLStudies on 15 September 2014

To be brief. What to do when PATH variable is too long to be real PATH.

Sometimes after installing pretty useful addins when starting SSMS you can see error message like "Exception has been thrown by the target of an invocation"

That can mean that your PATH variable is tooooo long to fit some system functions - and SSMS crashes.
Question "Why one function allows to…

Read more

0 comments, 74 reads

Posted in SQL Code Guard on 15 September 2014

Creation & Deletion of Database Snapshot by SQL Agent Job

Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want to delete the oldest with same frequency. Quite interesting scenario. I did not go in deep why he has such requirement but I am clear that It can be… Read more

0 comments, 90 reads

Posted in MSSQLFUN on 15 September 2014

Houston TechFest 2014: SQL Admin Best Practices with DMV's

Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014, thanks very much for attending! There were some exceptionally useful questions raised today, great job to my audience.

Here is the .zip file as promised for my presentation slide deck and .sql…

Read more

0 comments, 114 reads

Posted in SQL Tact on 13 September 2014

Older posts