FreeCon, October 27, 2015 Seattle

The company that I work with, SQL Solutions Group, is conducting a free community event. The week of the PASS Summit, on Tuesday, we will be hosting a day of free training. This is an event for all data professionals who happen to be in the Seattle area the days leading up to Summit but […]

The post FreeCon, October 27, 2015 Seattle appeared first on Wayne Sheffield.

By |September 23rd, 2015|SQL, SQL Group|Comments Off on FreeCon, October 27, 2015 Seattle

FreeCon, October 27, 2015 Seattle

The company that I work with, SQL Solutions Group, is conducting a free community event. The week of the PASS Summit, on Tuesday, we will be hosting a day of free training. This is an event for all data professionals who happen to be in the Seattle area the days leading up to Summit but […]

The post FreeCon, October 27, 2015 Seattle appeared first on Wayne Sheffield.

By |September 23rd, 2015|SQL, SQL Group|Comments Off on FreeCon, October 27, 2015 Seattle

What Sessions are Deployed?

As a DBA, it is not uncommon to feel like you are marooned off on some tiny little island trying to figure things out for yourself. It may even be very common to feel the icy pain of the development cold shoulder (intentional or not) as you go about doing your duties to protect the […]

By |September 1st, 2015|Extended Events, SQL, SQL Group|0 Comments

Defaults In msdb Database

Today is a day to discuss defaults. It started with the day being TSQL Tuesday and having a topic of “Say No to Defaults.” You can read more about that from the invite – here. I already participated in the party but did also want to discuss msdb Database defaults a little bit more. That […]

By |July 15th, 2015|SQL, SQL Group|0 Comments

The Interview Trick Question

Today, I am diverging from the more technical posts that I routinely share. Instead, as the title suggests, I want to dive into a something a little more fun: the interview trick question.

Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick […]

By |May 21st, 2015|SQL, SQL Group|0 Comments

Quick Permissions Audit

Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what.  In addition, they may need to know by what means people have access within your databases. Enter the permissions audit.

When that need arises, it is frequently adequate to just perform […]

By |May 13th, 2015|SQL, SQL Group|0 Comments

Automating DBCC DBTABLE – Obtaining the Disk Sector Size

It’s a best practice to have the disk sector size (also known as the allocation unit size or block size) set to 64kb (see this white paper), so how can you get that info programmatically?

I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost […]

By |April 28th, 2015|SQL, SQL Group, SQL Server|2 Comments

Upgrading From SQL Server Profiler

You may recall an article I had written a couple months back describing how to use Extended Events to perform your SQL Server Profiler duties. If not, you can read all about it here.

In that article, I showed one common use-case for SQL Server Profiler and how to achieve the same result via Extended Events. […]

By |April 22nd, 2015|SQL, SQL Group|0 Comments

Where did the Database Go?

What do you do when a developer comes to you and asks, “Where did the database go?  The database was there one minute, and the next it was not.”  Only one thing could be worse than the feeling of losing a database on your watch, and that would be losing a production database. It’s like […]

By |April 7th, 2015|SQL, SQL Group|0 Comments

How To: XEvents as Profiler

A common excuse for not delving into extended events seems to be the jump from Profiler to extended events (aka XEvents).  There appears to be an inherent fear with how to use extended events.  In addition to that fear, is the fear that extended events does not do what Profiler can do so easily.

Today, I […]

By |March 11th, 2015|SQL, SQL Group|2 Comments