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

Latest Blog Posts

SQL Saturday 582 Melbourne (11 Feb 2017) and Ignite 2017 (14-17 Feb 2017)

For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast

  • SQL Saturday 582 (Sat 11 Feb 2017).  Melbourne.  For those looking for some great free local SQL (and related!) learning, you simply cannot go past a SQL Saturday anywhere in…

Read more

0 comments, 70 reads

Posted in Mr. Fox SQL on 17 January 2017

Publish Power BI Reports to SSRS On-premise Preview Now Available

This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical Preview now available”  This feature addition will allow Power BI reports to be published to a local SQL Server Reporting Services server, entirely-on-premises without using the Power BI cloud service.…

Read more

3 comments, 148 reads

Posted in SQL Server BI Blog on 17 January 2017

Joint OPASS/MagicPASS Meeting Tomorrow Night (January 18, 2017)

Grant Fritchey will be presenting Faster Provisioning with SQL Clone and Denny Cherry is presenting Optimizing SQL Server Performance in a Virtual Environment. The event is being held at Nova Southeastern in Orlando. Register (Free) at Hope to see you there!


Read more

0 comments, 223 reads

Posted in SQLAndy on 17 January 2017

Team Collaboration with Microsoft OneNote

I was an early adopter of Microsoft’s OneNote and started using it in February of 2004 and have never stopped. I love it for the simplicity of use and ease of collaborating with a team. Team collaboration with Microsoft OneNote is a huge productivity gain and one of the main… Read more

0 comments, 77 reads

Posted in Marc Beacom on 17 January 2017

Power BI Subscriptions

Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in Microsoft BI in the past this idea is likely familiar to you. This new feature shares some similarities to Subscriptions in Microsoft Reporting Services.

The idea of subscriptions is to… Read more

0 comments, 103 reads

Posted in Devin Knight on 17 January 2017

Getting My Alias in #SQLPrompt

I got a tweet after my SQL Prompt formatting piece that said a user would be interested in upgrading from v5 if “as ‘Alias’” was transformed into “’Alias’ = “.

Well, in v7.3, this is in there, and I didn’t realize it. You can clearly see this in the formatting… Read more

0 comments, 102 reads

Posted in The Voice of the DBA on 17 January 2017

Power BI Custom Visuals Class (Module 34 – Sankey with Labels)

In this module you will learn how to use the Sankey with Labels Power BI Custom Visual.  The Sankey with Labels is a type of diagram that visualizes the flow of data between a source and destination columns. This is visual is similar to the visual we showed in Module… Read more

0 comments, 62 reads

Posted in Devin Knight on 17 January 2017

Upcoming Class: Building Better SSIS Packages in Pensacola

I’ll be teaching my popular day-long course, Building Better SSIS Packages, on Thursday, June 1 in Pensacola, Florida. This class is being delivered in conjunction with SQL Saturday Pensacola. Registration is open to the public, and early-bird pricing is in effect until early May. Let me know if you have… Read more

0 comments, 75 reads

Posted in Tim Mitchell on 17 January 2017

The two types of IT worker

Last week I published this post about something a colleague noticed when playing around with a SQL Server instance running on Linux. Fairly innocuous and I was chuffed when I saw that the guys over at had linked to it in their weekly newsletter.

As the day wore on,… Read more

5 comments, 1,815 reads

Posted in The DBA Who Came In From The Cold on 17 January 2017

Looking at wait stats differently with SQL 2016

Wait statistics is a great place to start looking into performance issues. Normally people would issue commands/queries based on  sys.dm_os_wait_stats and/or sys.dm_os_waiting_tasks. Did you know from SQL 2016 you have the ability to work with wait stats at a session … Continue reading

Read more

1 comments, 367 reads

Posted in All About SQL on 16 January 2017

Reminder: Extending DevOps Practices to SQL Server Databases with Redgate

I’m hosting a  new webinar on the DLM tools from Redgate Software and database DevOps. Tomorrow, Tues, Jan 17, at noon EST, Arneh Eskandari, a great sales engineer, will be demoing the tools and techniques to deploy changes.

You can register here and I’ll talk to you on tomorrow. Read more

0 comments, 113 reads

Posted in The Voice of the DBA on 16 January 2017

Monday Morning SQL Break – January 16, 2017

It’s Monday and time, finally, for a weekly blog and twitter round-up for last week.  It’s been a while since I’ve published this summary post, but hey that’s what life is for, getting in the way of things that you sometimes want to be doing.  If you haven’t already, follow… Read more

0 comments, 81 reads

Posted in StrateSQL on 16 January 2017

The Top 20 SQL Toolbelt Tips

Redgate produces some great software, and I’m glad that I get to use all of them as a developer and DBA. I use many of the tools each week, some daily, but I constantly find that there are plenty of features, tips, and tricks that I don’t know about.

At… Read more

0 comments, 126 reads

Posted in The Voice of the DBA on 16 January 2017

SQL Saturday Chicago Precon – Updated

UPDATE: The SQL Saturday in Chicago this year has hit peak capacity two months before the event! However, if you enroll in one of the precons, and hopefully my “The Complete Primer to SQL Server Infrastructure and Cloud” session, email the SQL Saturday coordinators with your EventBrite receipt… Read more

0 comments, 78 reads

Posted in Technobabble by Klee from @kleegeek on 16 January 2017

What is COPY_ONLY?

You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. Just in case you haven’t: You should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain.

But you may… Read more

2 comments, 1,495 reads

Posted in SQLStudies on 16 January 2017

Monday Coffee 2017-01-16

I’ve been a scribbler for as long as I can remember, in fact I’m not sure that I write everything down because I have a bad memory or if I have a bad memory because I write everything down.

About a year ago I stopped using notepads and tried to… Read more

0 comments, 98 reads

Posted in The DBA Who Came In From The Cold on 16 January 2017

Nolock vs snapshot isolation

We all experienced blocking one way or the other, in the old days, the only method is wait J

This is not entirely true you might say, as you can always change the code to include nolock table hint so that it can perform a dirty read. Yes, that seems…

Read more

3 comments, 1,749 reads

Posted in Dennis's SQL Blog on 16 January 2017

What’s new in SQL Server 2016 installation?

1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules it will automatically moves to Next window.

2) On Server Configuration page, MS specifically ask to GRANT PERFORM VOLUME MAINTENANCE TASK permission to service account. SQL Services needs this access… Read more

0 comments, 120 reads

Posted in MSSQLFUN on 16 January 2017

Weekly Newsletter

This week we started our Centino Systems weekly newsletter. Check out the first edition here!

The newsletter is going to include the latest in SQL Server and other things in technology that I think are important or interesting…and maybe you will too!

So if you’d like to subscribe to… Read more

2 comments, 285 reads

Posted in Anthony Nocentino's Blog on 15 January 2017

Upcoming SQL Server Events from PASS

There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write this blog, I glance over at twitter for hash tag #SQLSatNash and see all the speakers, volunteers and attendees express their love of this free event. You really never see… Read more

0 comments, 894 reads

Posted in The Smiling DBA on 14 January 2017

Newer posts

Older posts