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

Latest Blog Posts

SQL Server vs Oracle: How to replace NULL values

It’s Wednesday and that means another SQL/Oracle post. Today we’ll be discussing NULL Values, which can sometimes be a real pain. Don’t worry though there’s a simple solution. Simply replace the NULL value with another.

Comparing a column with NULL and replacing with another value is really simple. There are… Read more

1 comments, 145 reads

Posted in Confessions of a Microsoft Addict on 16 August 2017

Attaching databases via a dockerfile

Last week I presented my session on SQL Server & Containers for the PASS Virtualization Group and during my prep I noticed that there’s some functionality available to Windows containers and not Linux containers.

One of the (if not the) main benefits of working with SQL in a container… Read more

0 comments, 208 reads

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

Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL

This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script includes various columns that show the internals of a database, backup size, and gives the latest completion statuses and the corresponding backup sizes. Though the output is derived from the… Read more

0 comments, 141 reads

Posted in PowerSQL By Prashanth Jayaram on 15 August 2017

Automatic Sample Sizes for Statistics Updates

I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full scan, or you can specify an amount of data to sample, either a percentage of the table size, or a fixed number of rows. You can also choose not to… Read more

0 comments, 183 reads

Posted in Matthew McGiffen DBA on 15 August 2017

Bad Parameter Sniffing Decision Flow Chart

Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to help with this, I’m going to try to make a decision flow chart to walk you through the process. This is a rough, quite rough, first draft.

I would love… Read more

3 comments, 137 reads

Posted in The Scary DBA on 15 August 2017

Always Encrypted with Azure Key Vault

I recently wrote a post about using Transparent Data Encryption (TDE) with Azure Key Vault as an alternative to managing certificates. Today’s post will explore using SQL Server’s Always Encrypted functionality with Azure Key Vault. Always Encrypted, as with TDE, can use Windows certificates or what an external storage location… Read more

0 comments, 226 reads

Posted in Bradley Schacht on 15 August 2017

PASS Summit 2017

Don’t you want to go to the single largest collection of Microsoft Data Platform professionals and developers on the planet? Sure you do.

PASS Summit 2017 is coming up. Now is the time to register for this unique event.

This year I’ve been honored to be able to present a… Read more

1 comments, 190 reads

Posted in The Scary DBA on 14 August 2017

Using Merge–#SQLNewBlogger

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

I was playing with some data, loading it into staging tables and then moving it to a real table. I typically have done this with T-SQL, writing efficient… Read more

0 comments, 459 reads

Posted in The Voice of the DBA on 14 August 2017

Randomness in Security Configuration

We were deploying a new web service. Because of the nature of the service, we wanted it to listen on a non-standard port. Security by obscurity doesn’t work against a real attacker or well-written malware. However, if someone was just attempting to check for a web server by doing the… Read more

0 comments, 203 reads

Posted in Databases – Infrastructure – Security on 14 August 2017

Installing the (currently) latest Data Tools

I’m working on a project right now and it’s going to require me not only to refresh my SSIS skills a bit but learn a few things that are only available with the latest tools. So everyone ready for a few SSIS posts? Good. Me too!

Step One and Post… Read more

5 comments, 135 reads

Posted in SQLStudies on 14 August 2017

Fix for Blurry SSMS in Windows 10

I recently got a new laptop with Windows 10. I noticed SQL Server Management Studio (SSMS 17.1) was looking a bit blurry on my laptop screen. On another screen, it looked fine though. The cause for this is easy to find in the display settings. My primary screen is scaled… Read more

1 comments, 149 reads

Posted in Koen Verbeeck on 14 August 2017

Azure Cloud “Fear” Busting #4 – Losing Control?

So the decision to move to the cloud has been made but there is a fear from people that once it happens they will lose control of their job function. Does this sound familiar? DBA’s, you will be needed but expect some sort of change (That’s my opinion).

The way… Read more

3 comments, 131 reads

Posted in All About SQL on 14 August 2017

Monday Coffee: Time Off

Nice to be back after a week off. I’ve been writing three posts a week (sometimes more) since the beginning of the year so decided last week that I’d take a (albeit short) break.

It got me thinking about actual time off and how different people deal with taking a… Read more

0 comments, 136 reads

Posted in The DBA Who Came In From The Cold on 14 August 2017

PSDay.UK Tickets are on sale

Following a lot of hard work by the organising folks Gael Colas, Ebru Cucen, Daniel Krebs and Johnathan Medd, we are pleased to announce that the PSDay.UK tickets are now on sale.

If you just want to go and get a ticket click here


The first of the PSDay… Read more

0 comments, 146 reads

Posted in SQL DBA With A Beard on 13 August 2017

Building Your Brand and Becoming a Thought Leader Session Materials

Thank you to everyone that attending my session today at SQL Saturday #649 in Jacksonville, Florida! It was a packed room with over 70 people attending my session and the audience was lively! We had lots of great questions and tons of awesome interaction! If you want to download my… Read more

2 comments, 170 reads

Posted in SQL with Dustin Ryan on 12 August 2017

Just Say No to Social Engineering Memes

These memes, from a security and privacy perspective, are nothing but trouble. Here’s an example I just saw a friend respond to:

The reason I say trouble is because if you play along, they reveal a tremendous amount of personal information about you. That information is often used to secure… Read more

1 comments, 253 reads

Posted in Databases – Infrastructure – Security on 11 August 2017

SQL Server vs Oracle: Convert string to date

Over this week we’ve looked at the difference between Oracle and SQL Server from a few different angles. We’ve looked at date formatting, end of month, top rows, and pagination.

Finishing out the week  I’d like to return to dates and discuss how each platform can create a… Read more

3 comments, 40 reads

Posted in Confessions of a Microsoft Addict on 11 August 2017

Microsoft Azure – How to create a virtual machine (VM) with Reserved Public IP (VIP)

In my previous blog, we learnt that a Virtual IP (VIP) get lost or changed when we stop or deallocate the virtual machine (VM). So, to overcome this we can assign a reserved IP so that whenever we restart the virtual machine we would get the same IP. Microsoft Azure…

Read more

0 comments, 324 reads

Posted in Kapil Blogs on 11 August 2017

What-If Analysis in Power BI Desktop

One of the most talked about features previewed during the Microsoft Data Insights Summit in the previous June was the What-If Analysis capabilities. Today, this capability was finally released as part of the August update to Power BI Desktop.

New to Power BI? Start here!

The What If Parameter… Read more

1 comments, 163 reads

Posted in SQL with Dustin Ryan on 11 August 2017

You Can Now Put Values On Rows In Power BI

Back in January 2016, I wrote a blog post explaining a DAX workaround that allows you to put measures on rows in a matrix in a Power BI report. I’m happy to say that you no longer need my workaround because you can now natively put measures on rows in… Read more

2 comments, 351 reads

Posted in Data Savvy on 11 August 2017

Newer posts

Older posts