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

Confessions of a Microsoft Addict

Daniel Janik has been supporting SQL Server for 18 years as a DBA, developer, architect, and consultant. He spent six years at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has spoken at several SQL Saturday events across the US and Caribbean and regularly speaks at PASS local chapters.

Archives: June 2016

Does my database have data type drift?

Over the years I have come to see that every database has what I call data type drift. Simply put, data type drift is when you have columns with the same name but different data types or length. I’d say about 97% of databases I’ve reviewed have some form of… Read more

8 comments, 2,262 reads

Posted in Confessions of a Microsoft Addict on 28 June 2016

Are my SQL logins weak?

Security is a vital component of data security. In today’s day and age it is imperative to think about security. Recently there have been many high profile examples of data theft. This is a very simple script which allows you to find any SQL Server authenticated accounts that have either… Read more

0 comments, 1,266 reads

Posted in Confessions of a Microsoft Addict on 24 June 2016

Is Resource Monitor (resmon) all I need to troubleshoot storage?

I was recently doing some work on my Windows 10 desktop and placed a drive on one of the slower internal disks. It’s old. It’s 7200 RPM. It’s just plain slow. All that’s fine and good as I’m not doing any production workloads from this development machine.

I thought that… Read more

1 comments, 1,299 reads

Posted in Confessions of a Microsoft Addict on 23 June 2016

Microsoft finally got SQL setup right!

This past week, Microsoft revealed that SQL Server 2016 will be available in June. Exciting news indeed! With that said, I thought I’d take a few moments to point out some neat new features housed in SQL Server 2016 Setup.

As you can see from the following image, SQL… Read more

0 comments, 317 reads

Posted in Confessions of a Microsoft Addict on 22 June 2016

SQL Server Security Series, part 1

In the first entry in this SQL Server security series, we will demonstrate a brute force attack against SQL Server and discuss various techniques to protect against one. Brute force attacks are nothing new. They have been around for a long time and are very simplistic by design. The recent… Read more

0 comments, 312 reads

Posted in Confessions of a Microsoft Addict on 22 June 2016