SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

My Session about SQL Server Parameterization


Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the session was “How to Use Parameters Like a Pro and Boost Performance”.


Here is the abstract:


“Parameters are a fundamental part of T-SQL programming, whether they are… Read more

0 comments, 161 reads

Posted in Guy Glantser on 10 May 2017

SQL Server 2017 running on Windows Containers!

One of the questions which I normally get all the time whenever I talk about SQL Server and Docker is – Why you want to run SQL Server on containers?

Here is what Microsoft has to say:

“Windows Containers are an isolated, resource controlled, and portable operating environment. An application…

Read more

0 comments, 388 reads

Posted in SQLSailor.com on 10 May 2017

Setting Up a Subscription

In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I will request you to go through before you start exploring this blog.

If you don’t have the Subscription database, You must create your subscription database. Once you created the… Read more

0 comments, 163 reads

Posted in SQL Geek on 10 May 2017

Pester Test Inception and the Show Parameter

My fantastic friend Andre Kamman b | t  and I presented at PSConfEu last week

and whilst we were there we were chatting about running Pester Tests. He wanted to know how he could run a Pester Test and not lose the failed tests as they scrolled past him. In… Read more

0 comments, 131 reads

Posted in SQL DBA With A Beard on 9 May 2017

T-SQL Tuesday 90 - Shipping Database Changes

T-SQL Tuesday is a monthly blog party for the SQL Server community (or Microsoft Data Platform community. Although it’s called T-SQL Tuesday, it’s not limited to SQL Server database engine only). It is the brainchild of Adam Machanic blog | twitter.

This month’s tsql2sday is being hosted by James… Read more

0 comments, 721 reads

Posted in cjsommer.com on 9 May 2017

T-SQL Tuesday #90 – The Elephant’s Name is Database

T-SQL Tuesday is a monthly blog gathering for the SQL Server/Data Professional community  It is the brainchild of Adam Machanic (B|T) and is not limited to just things around the SQL Server database engine. Each month a blogger hosts the event and anybody who wants to… Read more

0 comments, 853 reads

Posted in John Morehouse | Sqlrus.com on 9 May 2017

T-SQL Tuesday #90: The Death of the DBA in a DevOps World Has Been Greatly Exaggerated

It’s time for another iteration of the blog party known as T-SQL Tuesday. This month’s theme is Shipping Database Changes hosted by James Anderson (|@). Head on over to John’s announcement post and join in with the party by writing your own post or by just reading those that are…

Read more

Shipping Database Changes–T-SQL Tuesday #90

This is a good T-SQL Tuesday topic from James Anderson: shipping database changes. It’s especially poignant for me since I talk and present often on this topic. Much of my work at Redgate involves helping people implement DevOps for Databases, deploying changes smoothly and efficiently to databases.

I’ve got… Read more

0 comments, 242 reads

Posted in The Voice of the DBA on 9 May 2017

Power BI Custom Visuals Class (Module 50 – Narratives)

In this module you will learn how to use the Narrative Power BI Custom Visual.  The Narrative visual is developed by Narrative Science and it gives you the ability to automatically deliver analysis of your data.  The results look similar to a final report that a analyst might provide after… Read more

2 comments, 751 reads

Posted in Devin Knight on 9 May 2017

Slides from 24 Hours of PASS – Data Security

As promised, here are my slides from the 24 Hours of PASS on Data Security:

S1 – Brian Kelley_WhatYouAbsolutelyMustKnowAboutSQLServerSecurity (.pptx – 733 KB)

S7 – Brian Kelley_ProtectingDataAcrossTheEnvironment (.pptx – 1.3 MB)

Thanks for those who attended!

Read more

0 comments, 136 reads

Posted in Databases – Infrastructure – Security on 9 May 2017

Extended Events – I am dangerous (sometimes)

I did a dangerous thing, and I want to make sure that YOU DO NOT do the same. I was creating a couple of extended events sessions and was playing around with some actions. I ended up with the following … Continue reading

Read more

2 comments, 147 reads

Posted in All About SQL on 9 May 2017

Continuous Integration

It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us to talk about Shipping Database Changes. I actually have some experience with an aspect of this at a previous company and I thought this would… Read more

0 comments, 137 reads

Posted in SQLStudies on 9 May 2017

Webinar Followup: End to End Security with SQL Server 2016

I recently presented a free webinar for Pragmatic Works where I discussed new security features in SQL Server 2016. You can click here to watch the recording of the webinar if you missed it. In this follow up I wanted to post the scripts I used and link to a… Read more

0 comments, 122 reads

Posted in Bradley Schacht on 9 May 2017

Some stuff with Date and Time in SQL Server

I’m writing this post because I want to put some more stuff around dates and times in one place. I additionally teach SQL Server classes and often come up to talk about dates and times, and converting them to string representations. Of course I don’t always have time enough to… Read more

0 comments, 186 reads

Posted in Si vis pacem, para sql on 9 May 2017

T-SQL Tuesday #90 – Shipping database changes



Well, it’s T-SQL Tuesday time again  -the blog party started by Adam Machanic (blog | twitter) and this month hosted by “The Database Avenger”  James Anderson. This month we’re talking about Shipping Database Changes – something I’ve done many times and mostly correctly – although we… Read more

0 comments, 147 reads

Posted in measure twice, cut once. on 9 May 2017

Splitting Strings on SQL Server 2016

A small change, but a great one, in SQL 2016 is native support for splitting strings.

This has to be about the most common user defined function that people write in SQL Server. I’ve certainly seen it across many companies and clients that I’ve worked for over the years. From… Read more

0 comments, 250 reads

Posted in Matthew McGiffen DBA on 9 May 2017

Dynamic Data Masking

By David Postlethwaite


Dynamic data masking is a really useful new tool in SQL Server 2016. Keeping data safe is one of the most important tasks that a company has; this goes further than just making sure that users can only see their own data and hackers can’t get…

Read more

0 comments, 314 reads

Posted in The SQL DBA in the UK on 9 May 2017

T-SQL Tuesday #90 — Bringing Continuous Delivery to a ‘brownfield’ database system

This blog post is part of  T-SQL Tuesday #90 – Shipping Database Changes .

I have decided to write about  a client’s SQL Server based system that was having issues with deployment of code changes. The code changes were being deployed by a third party contractor.

The client engaged with… Read more

0 comments, 119 reads

Posted in The Hybrid DBA's Blog on 9 May 2017

Why PowerShell?

Why do I use PowerShell?

Well, here’s a little back story…last year I was involved in a Pluralsight Play by Play with Jason Helmick and Jeffrey Snover for launch of Open PowerShell on Linux and Mac. Before this video, I didn’t take PowerShell seriously. Basically, if I Google’d a problem… Read more

4 comments, 244 reads

Posted in Anthony Nocentino's Blog on 9 May 2017

Setting Up a Publication for Transaction Replication

In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can create a publication. Here, we will learn how to create a publication for Transaction Replication and how many jobs get created after the publication setup.

Create Publication

I’ll walk… Read more

0 comments, 112 reads

Posted in SQL Geek on 9 May 2017

Newer posts

Older posts