-->
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.

SQL Tuning: Finding statements for missing indexes

Missing indexes are an important part of the indexing strategy. I usually start with sys.dm_db_index_usage_stats to find both inefficient and unused indexes and then supplement with missing indexes.

The missing index DMVs are great but they’ve always been missing something.

What are they missing you ask? They currently tell… Read more

0 comments, 143 reads

Posted in Confessions of a Microsoft Addict on 20 April 2018

Query tuning: Apply yourself

It’s Friday and I’m ready for the weekend as I’m sure everyone else is. This weekend I’m looking forward to getting yard work done and browsing through the whoisactive SQL Ops Studio extension code.

I plan on writing a few posts on creating extensions; but, before we get to those… Read more

1 comments, 2,821 reads

Posted in Confessions of a Microsoft Addict on 6 April 2018

SSMS now has a vulnerability report

Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look how many people are listening to the perf tuning session vs the 3 people attending the security session.

Hopefully, this new feature will help those that are interested and those… Read more

0 comments, 152 reads

Posted in Confessions of a Microsoft Addict on 29 March 2018

The best overlooked addition to SQL 2016

Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the hip new thing as opposed to quality of life. I’ve even recently heard people complain to Microsoft that they only focus on new features instead of making existing ones better. Read more

4 comments, 229 reads

Posted in Confessions of a Microsoft Addict on 7 March 2018

Classifying your data in Azure SQL DB for GDPR

Azure SQL DB is a robust data platform that’s cloud native and can be managed from SQL Server Management Studio (SSMS); though, the management tasks available from SSMS for Azure SQL DB may not exist, such as: data classification.

You may have read my last post How to classify your… Read more

0 comments, 145 reads

Posted in Confessions of a Microsoft Addict on 6 March 2018

How to classify your data for GDPR

The right to be forgotten. It’s a concept that sounds great for people who are concerned about their personal information (PII) but it’s a complex issue for developers and data professionals.

GDPR is the European law that is intended to empower individuals with the ability to control the surface area… Read more

0 comments, 199 reads

Posted in Confessions of a Microsoft Addict on 5 March 2018

SQL Saturday Chicago: I’m speaking

If you’re in Chicago on March 17 and have some free time, why not check out all the cool kids?

You can check out the full event schedule here: http://www.sqlsaturday.com/719/Sessions/Schedule.aspx

There are a lot of great speakers and topics. Did I mention the Brent Ozar will be there? If that’s… Read more

0 comments, 144 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

STORPORT: Reading an ETL trace

One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it so much; but, I just do. When it comes to storage in Windows one of the best things you can do is capture an ETL trace for the STORPORT driver. Read more

0 comments, 1,466 reads

Posted in Confessions of a Microsoft Addict on 19 February 2018

PaaS and the ever changing role of the DBA

I’ve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list of DMVs and I’m a happy camper.

Perfmon is probably my best friend. It’s always there and happy to tell me the truth. It seldom falters and has helped me… Read more

0 comments, 1,422 reads

Posted in Confessions of a Microsoft Addict on 12 December 2017

How to be a successful innovator

Let’s say you have some obscure list of career goals for the year and one of those is to be a champion of innovation. I’m sure many of you reading this have probably run across goals like this before. I see a lot of people struggle with larger companies and… Read more

0 comments, 195 reads

Posted in Confessions of a Microsoft Addict on 9 November 2017

Always update your views

I last posted about changing a table without changing a view that represents the table and how this may affect the view.

In today’s quick post I’d like to show another issue brought about by not maintaining your views.

In case you missed the last post you can find it… Read more

1 comments, 233 reads

Posted in Confessions of a Microsoft Addict on 3 October 2017

Don’t forget to drop your views

I had a fairly puzzling issue today, which took a few minutes to figure out. Some time ago I created a “history” table. This was before temporal tables came out in SQL.

The history table and associated table were paired together so when a change is made to an account… Read more

4 comments, 2,627 reads

Posted in Confessions of a Microsoft Addict on 25 September 2017

SQL Server: The danger of large data types

Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.

Watch towers go on the corners, barracks go somewhere over there,… Read more

1 comments, 269 reads

Posted in Confessions of a Microsoft Addict on 22 September 2017

Offtopic: Lifehack: Old tech has many purposes

For those that don’t know, I live in Texas. Been here all my life. There are two main things north Texans worry about from mother nature: Tornados & Hail.

Hail has damaged quite a bit throughout my life. Mainly just cars and roofs but lawn furniture and windows are in… Read more

1 comments, 1,343 reads

Posted in Confessions of a Microsoft Addict on 11 September 2017

SQL Server: SARGability part 2

In case you missed the first post on this topic, you can read it here: SQL Server: SARGability. This post continues the series and today we’re going to discuss the dangers of functions.

Recently, I’ve seen several customers that have been placing functions around columns in the WHERE clause.… Read more

1 comments, 1,578 reads

Posted in Confessions of a Microsoft Addict on 7 September 2017

Thank you for Microsoft MVP

My head may very well explode. I was done some tuning today and glanced at the Outlook new mail notification. At first I thought it was spam and then I did a double take.

It was a thank you from Microsoft and notification that I was awarded MVP for 2017-2018!… Read more

2 comments, 300 reads

Posted in Confessions of a Microsoft Addict on 2 September 2017

SQL Server: SARGability

SARG is short for Search Argument. This is an important tuning term and something every developer and DBA should know. I plan to do a few blogs on this topic and today marks the first.

What is a Search Argument?

Simply put a SARG is a portion of… Read more

2 comments, 385 reads

Posted in Confessions of a Microsoft Addict on 31 August 2017

SQL Server vs Oracle: Substring

Continuing the comparison between these two database giants, we dive into the substring function. If you’ve been working with databases for a while, I’m sure you’ve had to parse a string and while you’d think these are the same they work a little different and I think Oracle may surprise… Read more

2 comments, 1,854 reads

Posted in Confessions of a Microsoft Addict on 23 August 2017

I’m speaking: SQL Saturday Orlando (Oct 7th 17)

It’s been a while since I’ve done a SQL Saturday and I’m happy to be joining the folks in Orlando again this year. I spoke there a couple years ago and had a great time so I’m sure this will not disappoint.
If you happen to be headed to the… Read more

0 comments, 217 reads

Posted in Confessions of a Microsoft Addict on 16 August 2017

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

3 comments, 1,789 reads

Posted in Confessions of a Microsoft Addict on 16 August 2017

Older posts