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

Latest Blog Posts

SQL Server 2016 Bug in R Integration?

 

I am studying the latest R integration with SQL Server 2016, and I believe I encounter a bug when using sp_execute_external_script. So here is the re-play of the bug;

If I run the following code, I will get an error.

 

-- this will return an error

exec…

Read more

0 comments, 3 reads

Posted in DBA Philosophy on 19 January 2017

Attending VTUG at Gillette Stadium Tomorrow

If you’re in the Boston area tomorrow, I urge you to go to this year’s Virtualization Technology Users Group (VTUG) Winter Warmer event tomorrow at Gillette Stadium. It’s better than a regional VMUG, and not just VMware specific. It’s covering all things infrastructure, virtualization, and cloud, and it’s held… Read more

0 comments, 39 reads

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

Why Use Red Gate’s SQL Multi Script?

Someone once told me at the shop that we have plenty of software utilities laying around that could be very useful that no one is utilizing. I got to thinking about that from a DBA standpoint; we are fortunate enough to have the Tool Belt from Red Gate and with… Read more

0 comments, 55 reads

Posted in The SQL Professor on 18 January 2017

Using Out-GridView To Pick Parameters–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

I was editing an article on PoSh and learned something cool. I can use Grid-View to surface an object in a pipeline and then change the items… Read more

0 comments, 66 reads

Posted in The Voice of the DBA on 18 January 2017

Scheduling Statistics Maintenance in Azure SQL Data Warehouse

The power and capabilities of Azure SQL Data Warehouse are pretty amazing. However, it’s still basically SQL Server under the covers. SQL Server still needs maintenance and one type of maintenance is keeping statistics up to date. Statistics maintenance is doubly important within Azure SQL Data Warehouse because statistics are… Read more

3 comments, 60 reads

Posted in The Scary DBA on 18 January 2017

PowerShell Virtual Group of PASS January Newsletter

We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS.  But hey, we’re database people, not email mavens, and the newsletter does go out to over 4,000...

Read more

0 comments, 71 reads

Posted in SQLvariant on 18 January 2017

Lead Blocker

Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and no, NOLOCK doesn’t avoid them) we will have blocking. Typically it’s going to be very brief and you won’t even notice it. But sometimes you get a query or… Read more

0 comments, 52 reads

Posted in SQLStudies on 18 January 2017

Data Channel - Interview 03 - Hamish Watson on DevOps and Azure


Dear All,

After a short break, we are back with the 3rd interview on #DataChannel. Mr.Hamish Watson, Community Lead from Christchurch, New Zealand discusses "DevOps Practices and Azure" with me.  Had a great time as always talking technology with the ever awesome Hamish. Interview recording provided below




Interview transcript to…

Read more

0 comments, 56 reads

Posted in SQL and SQL Only on 18 January 2017

Steps to Configure SQL Server to Listen On A Specific TCP Port

Management of the database is very much essential in today’s date and for doing this, there is a need to have a platform. SQL Server is one such platform to manage the database in a relational manner. It was developed by Microsoft and operated by many users, especially in different… Read more

0 comments, 72 reads

Posted in Zora's SQL Tips on 18 January 2017

SQL database built-in intelligence

I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in Azure. SQL database has built-in intelligence and with that intelligence it may recommend an elastic pool setup if it’s more … Continue reading

Read more

1 comments, 168 reads

Posted in All About SQL on 18 January 2017

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, 58 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

2 comments, 90 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 https://www.eventbrite.com/e/sql-sons-of-beaches-tour-tickets-30043366518. Hope to see you there!

 


Read more

0 comments, 194 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, 62 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, 88 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, 91 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, 56 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, 66 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 BrentOzar.com had linked to it in their weekly newsletter.

As the day wore on,… Read more

0 comments, 104 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, 331 reads

Posted in All About SQL on 16 January 2017

Older posts