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

Latest Blog Posts

I’m speaking at the first ever SQL Saturday San Antonio on 8/13/16!

San Antonio is such a great city with a lot to see and do, such as the Alamo and the river walk. I’m excited to be speaking at their very first SQL Saturday!!

My session is on troubleshooting and monitoring storage, including SAN, flash, and in Azure. If you ever… Read more

0 comments, 87 reads

Posted in Confessions of a Microsoft Addict on 23 July 2016

Thank You SQL Saturday Sioux Falls!

I just finished giving my SQL Saturday presentation on "Getting Started with Extended Events" at SQLSaturday Sioux Falls.  The audience was great with some multiple questions and follow-ups, so it was awesome!

The sessions have been informative and the event team has done a wonderful job with all of…

Read more

0 comments, 52 reads

Posted in Nebraska SQL from @DBA_ANDY on 23 July 2016

Speaking at DevConnections 2016

I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This is my fourth (if I remember correctly) time to have spoken at DevConnections, and the first time I will have delivered a full-day workshop there. This year… Read more

0 comments, 96 reads

Posted in Tim Mitchell on 22 July 2016

Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Sacramento)

Prakash will walk you through a centralized process using PowerShell where the key information collected, organized and sent via HTML formatted email, provides consolidated view of SQL server along with key observations which DBA should verify and share with IT stakeholders for increasing transparency and improved efficiency

Read more

0 comments, 80 reads

Posted in SQLFeatures on 22 July 2016

What’s Database Drift?

The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context of the schema of your database, I can see the code “drifting” away from what you expect. Someone noticed this was a problem when implementing continuous delivery and DLM Dashboard Read more

1 comments, 158 reads

Posted in The Voice of the DBA on 22 July 2016

Overview of Published Articles – 2016Q2

Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL Server 2016:

Read more

0 comments, 124 reads

Posted in Koen Verbeeck on 22 July 2016

Day 3: Agile Fundamentals: Scrum, Kanban, Lean and XP

It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum, Kanban, Lean and XP After the pre-course meeting with Alan O'Callaghan on Tuesday evening and sitting through Day1 and Day 2 this is turning into an interesting week for me and…

Read more

0 comments, 98 reads

Posted in The SQL DBA in the UK on 22 July 2016

Another Query to Help Find the Right Event

Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events. In this follow-up article to Extended Event Help Queries, I will share another means to quickly explore the… Read more

0 comments, 142 reads

Posted in SQL RNNR on 21 July 2016

Using a Lookup Component in SSIS for Surrogate Keys in a Fact table

There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to repeat for facts and dimensions. This might be because the consistency Dimensional Modeling suggests for the design of fact and dimension tables. The SSIS Lookup component…

Read more

0 comments, 75 reads

Posted in The Smiling DBA on 21 July 2016

Rename a Primary Key–#SQLNewBlogger

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

Having system named objects is one of those things that people may debate, but as you move to more automated and scripted processes can cause you issues.… Read more

0 comments, 107 reads

Posted in The Voice of the DBA on 21 July 2016

Off topic–Would you SQL your license plate?

I was recently browsing www.myplates.com and I’ll say it’s actually quite fun to see what plates people have randomly bought. I found it easy to spend 15 or so minutes typing in all sorts of fun and silly things into the search just to see what would come up.

Here’s…

Read more

1 comments, 77 reads

Posted in Confessions of a Microsoft Addict on 21 July 2016

SQL 2016 SSIS new feature AutoAdjustBufferSize

If you have not already seen in the What’s New in Integration Services list there is a new property for Data Flows that is called AutoAdjustBufferSize.  Why is this important and what does it actually do?

First, let’s remember that in SQL 2014 we had a max DefaultBuffersize of… Read more

0 comments, 143 reads

Posted in Another SQL Geek on 21 July 2016

SQL Server: Consolidation Tactics and Best Practices

My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I spend just over two hours sharing my experiences and knowledge of consolidating numerous clients over the years.

I had a lot of fun working on this course and… Read more

0 comments, 97 reads

Posted in Tim Radney - Database Professional on 21 July 2016

Limitation of In-Memory OLTP in SQL Server 2016 – Sp_rename not allowed

Hi friends, one more limitation of In-Memory OLTP is SQL Server 2016 is that sp_rename is not allowed to change the name of in-memory OLTP objects. Sp_rename is a system stored procedure which allows to change the name of the user-defined objects like table name, column name, datatype of a…

Read more

0 comments, 113 reads

Posted in Kapil Blogs on 21 July 2016

ReadyRoll and Octopus Deploy Webinar

I’ll be hosting a webinar next week, Thursday, July 28, with Daniel Nolan (t) (founder of ReadyRoll and fellow Redgate employee) and Damian Brady (b | t) of Octopus Deploy.

We’ll be talking deployment, with demos to show you how to work with ReadyRoll for… Read more

0 comments, 142 reads

Posted in The Voice of the DBA on 21 July 2016

Great Value IT Training - 21st July

As I have mentioned in previous posts, we have done a deal with Learning Tree to be able to offer you selected courses from their public course schedule at a great price. £750 plus VAT. We  have received this week’s updates and it includes some great courses. You can find…

Read more

0 comments, 80 reads

Posted in The SQL DBA in the UK on 21 July 2016

Join me at SQL Saturday 531, Louisville, KY

So, I have the privilege of not only delivering a regular session, Introduction to Power BI Desktop, at SQL Saturday 531 Louisville, KY, but also a pre-con.  The pre-con Power BI:  Beginning to End, is a full day of Power BI including hands-on labs.  An overview… Read more

0 comments, 123 reads

Posted in SQLDownSouth on 21 July 2016

Day 2: Agile Fundamentals: Scrum, Kanban, Lean and XP

It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum, Kanban, Lean and XP After the pre-course meeting with Alan O'Callaghan on Tuesday evening and sitting through Day1  this is turning into an interesting week for me and I have…

Read more

0 comments, 117 reads

Posted in The SQL DBA in the UK on 21 July 2016

Growth or Control – #sqlpass

I’m disturbed.

I read an announcement from the PASS organization this week that bothers me. I am less upset with the content than the manner in which it was presented, though I am not pleased with either.

Making SQL Saturday Sustainable was released this week, with a few changes to… Read more

22 comments, 174 reads

Posted in The Voice of the DBA on 20 July 2016

Remove-SQLDatabaseSafely My First Contribution to DBATools

What is DBA Tools?

A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now grown into a collection of various commands that help automate DBA tasks and encourage best practices.

You can read more about here and it is freely available for download… Read more

0 comments, 162 reads

Posted in SQL DBA With A Beard on 20 July 2016

Older posts