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

Latest Blog Posts

Steps to Restore Database from Backup File In SQL Server


In most of the cases, users create a backup file of their database on their machine. This help the users to perform recovery at the time of any disaster, or manage large amount of database onto the SQL server. However, users generally knows the way to create a backup… Read more

0 comments, 165 reads

Posted in Zora's SQL Tips on 21 September 2016

What makes a successful Tech Conference? // Was macht eine erfolgreiche technische Konferenz aus?


After my Asia-tour this summer I feel it is about time for this article.
At the time of this article (09-2016) I have presented at more than 50 technical conferences around the world (Europe, Middle East, Asia, North America), from small with about 150 attendees to huge with around…

Read more

0 comments, 168 reads

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

“Witch” Statistics?

Three men are in a hot-air balloon. Soon, they find themselves lost in a canyon somewhere. One of the three men says, “I’ve got an idea. We can call for help in this canyon and the echo will carry our voices far.” So he leans over the basket and yells… Read more

0 comments, 117 reads

Posted in SQLYSE with Pankaj Manek on 20 September 2016

How to Setup Kerberos Correctly

David was in Copenhagen this weekend delivering his Kerberos talk Taming the Beast: Kerberos for the SQL DBA to SQL Saturday Denmark. I have had a quick chat with him via email since he got back and he said he had a great time. The event was very well attended…

Read more

3 comments, 1,336 reads

Posted in The SQL DBA in the UK on 20 September 2016

SSMS Keeps Crashing

It is quite frustrating when SSMS (SQL Server Management Studio) randomly crashes, all too often for my liking. If you have the following screen shot then read on. Digging into the event logs I noticed the following error: Faulting application name: Ssms.exe, … Continue reading

Read more

2 comments, 201 reads

Posted in All About SQL on 20 September 2016

Operational Analytics -SQL Server 2016

What is Operational Analytics:- Operational Analytics is a combination of two words “Operational” and “Analytics”. so your OLTP system is a operational system where day to day task eg order table keeps on updating. and Analytics is a OLAP where analysis … Continue reading

Read more

0 comments, 116 reads

Posted in Vinay Thakur on 20 September 2016

Database Deployments in Uncontrolled Environments

The ideal is to make a change and see that change deployed to production, in a perfect world we would be told to work on something, write the code + tests, deploy to a test environment, prove it works and deploy - this is the cycle time and the faster…

Read more

0 comments, 572 reads

Posted in Ed Elliott's Sql Developer Blog on 20 September 2016

North Texas SQL Server User Group – September 2016 Follow

Thanks for attending my presentation on window functions in TSQL during the September 15, 2016. I hope you learned something you can take back and use in your projects or at your work. You will find an link to the session and code I used below. If you have any… Read more

0 comments, 92 reads

Posted in DataOnWheels on 19 September 2016

Quick Script – Finding Most Recent Backup

Recently I have had to restore a number of databases into our training environment.   Looking up each backup individually would be time consuming and I prefer to save time whenever possible.  So, instead of lookup up the backup for each database I needed, I thought a quick script would be… Read more

0 comments, 806 reads

Posted in John Morehouse | on 19 September 2016

Data Governance Policy

What is a Data Governance Policy?

Data governance policy is concerned with how an organization collects, stores, accesses and maintains its data.  As data is now a core enterprise asset, ensuring it is properly maintained and controlled is critical.

When creating a data governance program there are at least 4… Read more

1 comments, 156 reads

Posted in Business Intelligence and Enterprise Architecture on 19 September 2016

Monday Morning SQL Break – September 19, 2016

It’s Monday and time for this week’s blog and twitter round-up. It’s been a few weeks since the last recap, apparently vacation a month and a half ago slowed my roll on blogging.  If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to… Read more

3 comments, 158 reads

Posted in StrateSQL on 19 September 2016

Query Store and Plan Forcing: What Do You Use It For

If you’re working with Azure SQL Database or you’ve moved into SQL Server 2016, one of the biggest new tools is the Query Store. It provides a mechanism of capturing query performance over time and persisting it with the database. You also get the execution plans for those queries. Finally,… Read more

1 comments, 656 reads

Posted in The Scary DBA on 19 September 2016

Power BI Custom Visuals Class (Module 17 – Sunburst)

In this module you will learn how to use the Sunburst chart Power BI Custom Visual.  The Sunburst chart is similar to the standard donut chart but allows you to show multiple level at once, which is great when presenting hierarchical data.

Module 17 – Sunburst


  • Power BI Custom…

Read more

0 comments, 978 reads

Posted in Devin Knight on 19 September 2016

Using an ORDER BY in a view

For many years it’s been a best practice to never put an ORDER BY in a view. The idea is that a view shouldn’t have an inherent order. Just like any other query. If you want the data from a view ordered then you query the view with an ORDER… Read more

10 comments, 2,498 reads

Posted in SQLStudies on 19 September 2016

Speaking at Suburban Chicago SQL Server Users Group Tomorrow

I will be presenting a technical session entitled ‘Virtual SQL Servers. Actual Performance‘ tomorrow evening for the Suburban Chicago SQL Server Users Group. Doors open at 5:30pm and the session starts at 6:00pm!

Abstract: Virtualizing your business-critical SQL Servers should not imply that they will run slower… Read more

0 comments, 78 reads

Posted in Technobabble by Klee from @kleegeek on 19 September 2016

Building Oracle 12c on Linux 7 on Hyper-V

David has written a white paper, or short ebook titled building oracle 12C on Linux 7 VM residing on Hyper-V. The white paper is in draft and has been tested but David would welcome further feedback.

As with everything on this site...The owner of will not be liable for…

Read more

0 comments, 77 reads

Posted in The SQL DBA in the UK on 19 September 2016

Books VS Internet

It’s is very easy to be confused between investing in books or we should use the power of internet. If you ask my recommendation, I would strongly suggest Books.  Why, let’s take a simple example. Suppose you want to watch a great movie let’s say Avatar. Now you have two…

Read more

0 comments, 15 reads

Posted in Help on MSBI on 19 September 2016

Distributed AG

going though Allan Hirt’s 24 SQLPASS  recording, he has explained the new feature of SQL Server Availability group you can get it here. he is expert in Clustering /AG/ and published several blogs and books. Distributed AG is advance and extended … Continue reading

Read more

0 comments, 113 reads

Posted in Vinay Thakur on 19 September 2016

5 Must Haves Before You Start Consulting

The most common questions I’m asked during networking sessions at technical conferences and events aren’t technical! People want to know what it’s like being an independent consultant. Things like how to get started and what to look out for are common themes.  So I wanted to share the some… Read more

0 comments, 134 reads

Posted in Anthony Nocentino's Blog on 19 September 2016

Azure IaaS Premium Storage Test

I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will have SQL Server installed. I will then show a comparison of the same test on my local (average) machine. DiskSpd … Continue reading

Read more

2 comments, 206 reads

Posted in All About SQL on 19 September 2016

Newer posts

Older posts