Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Speaking at PASS Summit 2016

There is a huge time for suspense for everyone in the Microsoft Data Platform space, whenever its time to submit sessions for the PASS Summit and even more, when the notification of the selection/non-selection are being sent to those who…

Read more

0 comments, 93 reads

Posted in Niko's blog on 25 June 2016

PASS Summit 2016 – Connect, Share, Learn

Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th. But before I talk about this year’s event, join me in a trip down memory lane about my path to the PASS Summit. If not, skip to the…

Read more

0 comments, 84 reads

Posted in The Smiling DBA on 24 June 2016

The Desktop Rebuild–Part 1

I’ve had an aging desktop for some time. I originally bought it from Glenn Berry (b | t), who I think gets a new machine every quarter or two. Seriously, I think there is a computer in every room of his house, and he has a lot of rooms.

In… Read more

1 comments, 105 reads

Posted in The Voice of the DBA on 24 June 2016

PASS Summit 2016 – My Session Evaluations - Syndication – WaterOx Consulting

No Sessions For You! The announcements of the speakers and sessions selected for the PASS Summit 2016 were recently announced, and I was not picked for any sessions. I do not have any ill feelings to those that go through the herculean effort to create the reviews and the Summit…

Read more

1 comments, 104 reads

Posted in WaterOx SQL on 24 June 2016

Problems When Running DBCC SHRINKFILE On SQL Server Database

Overview of the Situation

While accessing data files in SQL Server, many issues may occur that may lead to frustrating situation for users. One such situation occurs when user are running DBCC SHRINKFILE. There are many issues with running DBCC SHRINKFILE on your SQL Server data file. In the information… Read more

What do you want to learn about SSRS 2016 at PASS Global Summit?

I’m thrilled to have been selected to deliver a session at the 2016 PASS Global Summit titled “Reporting Services 2016: The Force Awakens”.  I’ve been speaking at SQL Saturdays and have done some training on SSRS 2016 this year but this new session has yet to be finished SO…. please…

Read more

2 comments, 112 reads

Posted in SQL Server BI Blog on 24 June 2016

Are my SQL logins weak?

Security is a vital component of data security. In today’s day and age it is imperative to think about security. Recently there have been many high profile examples of data theft. This is a very simple script which allows you to find any SQL Server authenticated accounts that have either… Read more

0 comments, 88 reads

Posted in Confessions of a Microsoft Addict on 24 June 2016

Is Resource Monitor (resmon) all I need to troubleshoot storage?

I was recently doing some work on my Windows 10 desktop and placed a drive on one of the slower internal disks. It’s old. It’s 7200 RPM. It’s just plain slow. All that’s fine and good as I’m not doing any production workloads from this development machine.

I thought that… Read more

1 comments, 89 reads

Posted in Confessions of a Microsoft Addict on 23 June 2016

Struggling With Due Diligence

It’s been a while since my last post, there are various reasons for my absence:  work, illness, having our house rewired, etc., but one of the biggest reasons is my struggle with how a few folks in the SQL community treat the PASS organization and those that volunteer their time… Read more

3 comments, 116 reads

Posted in SQL Swimmer on 23 June 2016

Update duplicate xml attribute values to unique value

I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why I hadn’t got this down into a blog post earlier!

Imagine the following contrived xml snippet which is essentially just a… Read more

0 comments, 68 reads

Posted in SQL Server Rocks! on 23 June 2016

Automating Azure Resource Management Authentication

I love Azure and I love PowerShell.  They are a perfect marriage. It’s amazing how much automation you can do inside of Azure with some PowerShell scripting. In fact, you hardly see me using the Azure Portal these days.

Automation is great until manual processes are required. I have been… Read more

0 comments, 59 reads

Posted in John Sterrett on 23 June 2016

Comparing databases using SSDT

Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!

The original question was “Does SQL Compare or others prods allow me to compare 1 “gold” db to the 57 “identical” databases in prod at once? asking for a… Read more

1 comments, 89 reads

Posted in on 23 June 2016

Selecting Speakers for the Summit

This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for the first time, but on topics that I think make better events. These are opinions and thoughts, not mandates or demands.

I attended, well, listened to, the PASS Speaker Selection… Read more

4 comments, 155 reads

Posted in The Voice of the DBA on 23 June 2016

Azure SQL Data Warehouse pricing

The pricing for Azure SQL Data Warehouse (SQL DW) consists of a compute charge and a storage charge.  For compute, it is not based on hardware configuration but rather by data warehouse units (DWU).  DWU can be scaled up or down via a sliding bar in just a… Read more

0 comments, 94 reads

Posted in James Serra's Blog on 23 June 2016

I’m speaking at Summit!

I’m excited to announce that I have been selected to speak at PASS Summit again this year! I’ll be presenting a new session, “Extending Applications Securely Using Service Broker”:

If you’ve ever tried to build a distributed application – one that spans multiple servers or even multiple sites – you…

Read more

0 comments, 86 reads

Posted in The Data Files on 23 June 2016

What if Your Employer Won’t Support Your Career?

I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t say every technical job I’ve had was all unicorns and bacon, I’ve been very fortunate to have been treated fairly and professionally through most of my employment history. Not only… Read more

2 comments, 87 reads

Posted in Tim Mitchell on 23 June 2016

Azure Cortana Intelligence Suite – with Azure Data Catalog

I presented at our local Melbourne SQL Server User Group (SSUG) this week on Azure Cortana Intelligence Suite – and the integration with the Azure Data Catalog.  If you are interested to see the presentation then have a look here –

One of the things which stood out… Read more

0 comments, 129 reads

Posted in Mr. Fox SQL on 23 June 2016

PASS Nominating Committee Update

Today PASS released a bunch of stuff for the upcoming election including the attributes of an “ideal candidate”. We put in quite a bit of time on that description, in part because people often ask “am I ready” and in part because it is the next step in doing a… Read more

0 comments, 126 reads

Posted in SQLAndy on 22 June 2016

Names From the Past

Can you guess what all of these people have in common?

  • Shawn Weisfeld
  • Joe Healy
  • Barry Ralston
  • Trey Johnson
  • Jon Winer
  • Wes Dumey
  • Donnie Reynolds
  • Kevin Jacobs
  • Joseph Memmo
  • Brian Knight
  • Michael Antonovich
  • Declan Link
  • Patrick Thompson
  • Jeff Garbus
  • Jim Blizzard
  • Ken Tucker
  • Jessica Moss
  • Bayer White
  • Joe Celko
  • Judy…

Read more

0 comments, 112 reads

Posted in SQLAndy on 22 June 2016

SQLSaturday Orlando 2016 Call for Speakers Closes July 17, 2016

We’ve advanced the closing date for the SQLSaturday Orlando call for speakers to July 17. That’s to give us time to set the schedule and have it announced around August 1, just a little more than 60 days before the event. We’ll get an email with that information out to… Read more

0 comments, 89 reads

Posted in SQLAndy on 22 June 2016

Older posts