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

Latest Blog Posts

Persisting data in docker containers – Part Three

Last week in Part Two I went through how to create named volumes and map them to containers in order to persist data.

However, there is also another option available in the form of data volume containers.

The idea here is that create we a volume in a container and… Read more

0 comments, 871 reads

Posted in The DBA Who Came In From The Cold on 5 July 2017

Celebrate Your Independence with Free Tools

Been working on this blog post for a while, thought I'd share today an inventory of tools I use regularly that are free to the DBA.

ZoomIt
https://technet.microsoft.com/en-us/sysinternals/zoomit.aspx
A nearly ubiquitous free Microsoft-provided download to provide for easy zooming, live zooming, drawing on your screen, and more. It is something…

Read more

0 comments, 234 reads

Posted in SQL Tact on 4 July 2017

Using Get-SQLDiagFix to get information from the SQL Server Diagnostic API with PowerShell

The SQL Server Diagnostics Preview was announced just over a week ago It includes an add-on for SQL Server Management Studio to enable you to analyse SQL Server memory dumps and view information on the latest SQL Server cumulative updates for supported versions of SQL Server. Arun Sirpal has written… Read more

1 comments, 929 reads

Posted in SQL DBA With A Beard on 4 July 2017

Database Mirroring Needs FQDNs

A quick basic post, and one that I’ve forgotten. Since blogging is a good way to remind myself of things, here goes.

I was testing Database Mirroring (DBM) recently for an upgrade situation. I’ve set up it up in the past, but since it’s deprecated, I’ve moved on to… Read more

0 comments, 200 reads

Posted in The Voice of the DBA on 3 July 2017

Toolbox - Where Did All My Space Go?

This is the first in a new series of blogs I am going to create talking about useful tools (mostly scripts) that I use frequently in my day-to-day life as a production DBA.  I work as a Work-From-Home DBA for a Remote DBA company, but 90+% of my job functions…

Read more

1 comments, 1,545 reads

Posted in Nebraska SQL from @DBA_ANDY on 3 July 2017

SQL Homework – July 2017

For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a number of blog posts myself. Here is part of his description of it:

Often the task is what I consider a low frequency / high liability…

Read more

8 comments, 166 reads

Posted in SQLStudies on 3 July 2017

24 Hours of PASS, Summit Preview Session

I’m proud to announce that I’ve been selected to present a session in this year’s 24 Hours of PASS: Summit Preview webinar series entitled Virtual CPUs: Right to Ludicrous Speed. This session is scheduled for July 20th, 2017, at 03:00 GMT, or July 19th at 11pm Eastern.

These… Read more

0 comments, 114 reads

Posted in Technobabble by Klee from @kleegeek on 3 July 2017

Creating the SSIS Catalog

If you are building SQL Server Integration Services (SSIS) packages, using the SSIS catalog as a deployment target is usually the easiest and most efficient solution. However, the SSIS catalog is not created by default, even when you select the SSIS components during the SQL Server installation process. The good… Read more

2 comments, 333 reads

Posted in Tim Mitchell on 3 July 2017

Building Always On Availability Groups - Part 1

Introduction

By David Postlethwaite

Ensuring that your databases can survive a major outage such as a server failure and can continue to work is an important task of being a DBA.
Database Mirroring was introduced in SQL 2005 and was quite straight forward to setup.
Mirroring only allowed for one…

Read more

4 comments, 1,249 reads

Posted in The SQL DBA in the UK on 3 July 2017

Monday Coffee: Alerts & Checks

Hope you all had a good weekend, the Lions won so I’m pretty happy.

Over the weekend I was thinking about the alert system that I have in place at my current position. A good alerting system is (obviously) essential for any DBA to have in place but we all… Read more

0 comments, 129 reads

Posted in The DBA Who Came In From The Cold on 3 July 2017

Update SSMS With PS1

With how many updates are coming out I threw together a script to parse the latest version from the webpage, and then provide a silent update and install if the installed version is out of date with the available version. To adapt for future changes, the script is easy to… Read more

0 comments, 1,234 reads

Posted in SQL Barbarian on 3 July 2017

Capture Important Parameters of the SQL Server Replication

Whenever there is a business requirement to add a new article to an existing publication, you want to know how the publication is going to behave during the initialization. Basically, you start asking following questions to yourself;

  • Will a new snapshot (running the snapshot agent of the publication) cause to…

Read more

1 comments, 709 reads

Posted in SQL Geek on 3 July 2017

Security Basics: The Principle of Least Privilege

Whenever I’m asked about creating a security model for an application or database, I tell folks to follow the Principle of Least Privilege. There are several definitions out there, some wordier than others. Here’s mine:

Give the permissions necessary to do the job. No more. No less.

If this is… Read more

2 comments, 1,583 reads

Posted in Databases – Infrastructure – Security on 30 June 2017

Don’t Forget the Keys

I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server 2016.  This came none too soon as SQL Server 2012 (SP3) goes out of mainstream support on July 11, 2017.

We decided to go with a brand new box since… Read more

0 comments, 1,582 reads

Posted in SQL Swimmer on 30 June 2017

Using Organization Hierarchies as Reporting Unit filters with Management Reporter

Well, hello. It has been more than three years since my last blog, since then I have been really busy at work and have a baby in the meantime. That being said, I wonder how much joy you guys have with playing with MR. I have been using Dynamics AX…

Read more

0 comments, 175 reads

Posted in Terry's Business Intelligence on 30 June 2017

VMworld 2017 USA Sessions

I’m proud to announce that my sessions for this year’s VMworld 2017 conference in Las Vegas have turned up in the VMworld Content Catalog! I have four exciting sessions (if you’re a database geek) at the conference, and for those DBAs with VMware administrators attending this conference, tell them to… Read more

0 comments, 160 reads

Posted in Technobabble by Klee from @kleegeek on 30 June 2017

Power BI Custom Visuals Class (Module 57 – Infographic Designer)

In this module you will learn how to use the Infographic Designer Custom Visual.  The Infographic Designer give you the ability to make your reports tell a story and even theme the visuals to be more relevant to the topic of your data.

Module 57 – Infographic Designer

Downloads

  • Power…

Read more

0 comments, 1,258 reads

Posted in Devin Knight on 30 June 2017

Implementing Fuzzy Sets in SQL Server, Part 11: Fuzzy Addenda

By Steve Bolton

…………One of the key reasons I looked into the topic of fuzzy sets in the first place was my suspicion that T-SQL, as a set-based language, would be ideal for modeling them. That turned out to be an understatement of sorts: I definitely was not prepared… Read more

0 comments, 141 reads

Posted in Multidimensional Mayhem on 30 June 2017

Creating a PowerShell Module and TDD for Get-SQLDiagRecommendations

Yesterday I introduced the first command in the SQLDiagAPI module. A module to consume the SQL Diagnostics API.

I have been asked a few times what the process is for creating a module, using Github and developing with Pester and whilst this is not a comprehensive how-to I hope it… Read more

2 comments, 211 reads

Posted in SQL DBA With A Beard on 30 June 2017

Friday Reading 2017-06-30

Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up early to watch it tomorrow, the team selection is here.

But anyway, this week I’ve been reading…

Using SQL Server Diagnostics
Arun Sirpal goes through how to use… Read more

0 comments, 123 reads

Posted in The DBA Who Came In From The Cold on 30 June 2017

Newer posts

Older posts