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

Archives: November 2018

My Book Contributions

It’s a Wonderful Life

One of the really super cool things about the SQL community is the frequent opportunity one could have to get involved.

One of my favorite methods of getting involved is the varied ways to participate on a book project. To be involved in a book project… Read more

0 comments, 253 reads

Posted in SQL RNNR on 30 November 2018

Data Professionals at Work Book

Working as a Data Professional

An old friend Malathi Mahadevan (b | t) asked me one day if I would be interested in helping with her first book project. Anybody who has participated in the writing of a book knows this can be a rather daunting task –… Read more

0 comments, 234 reads

Posted in SQL RNNR on 29 November 2018

How to be an MVP Book

How to be an MVP in LIFE

One of the fun things about being involved in the community is the opportunity to meet new people. Sometimes, meeting new people leads to new opportunities. Most of the time, those meetings turn into friendships of varying degrees.

One person I met at… Read more

1 comments, 277 reads

Posted in SQL RNNR on 28 November 2018

Auditing when Database Files Change

As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That means tracking when the log file grows and tracking when the data file(s) grow(s). Many will argue that there is nothing worse than not knowing when a database-related file changed… Read more

1 comments, 315 reads

Posted in SQL RNNR on 27 November 2018

Ghosts in your Database

Yes Virginia, there are ghosts in your database.  More specifically, there are ghosts in your SQL Server database.  They are not there to haunt you.  They are not there just for this holiday season (speaking of Halloween Month).

How can there be ghosts in the database?

Why would there be… Read more

0 comments, 2,509 reads

Posted in SQL RNNR on 26 November 2018

Azure Data Studio and XEvents

Azure Data Studio (ADS) is getting all sorts of love and attention these days. So much so that they have finally gotten around to adding Extended Events (XE) to the tool – sort of. Now we have the power to run traces on SQL Server via ADS.

The presence of… Read more

2 comments, 842 reads

Posted in SQL RNNR on 21 November 2018

How Long is That Event Taking

Knowing just how long an event takes is a common requirement when troubleshooting. Sometimes, figuring out the unit of time is a bit troublesome. Is it milliseconds, seconds or microseconds?

It is really easy to mistakenly use milliseconds when microseconds is required. It is also really easy to forget that… Read more

0 comments, 234 reads

Posted in SQL RNNR on 20 November 2018

PowerShell ISE Crashes

Working with PowerShell brings a lot of advantages and power to help manage a server. The more current your PoSh version, the more efficiently you will be able to manage your server. Sometimes getting to the current PoSh versions comes with a little pain such as ISE crashes.

I recently… Read more

0 comments, 238 reads

Posted in SQL RNNR on 19 November 2018

Monitor Database Offline Events

The other day, I shared an article showing how to audit database offline events via the default trace. Today, I will show an easier method to both audit and monitor for offline events. What is the difference between audit and monitor? It largely depends on your implementation, but I… Read more

1 comments, 1,861 reads

Posted in SQL RNNR on 15 November 2018

T-SQL Tuesday #108: New Horizons Beyond SQL Server

There comes a point in one’s career when a change is requisite. Big or small there always seems to be a tipping point that mandates some sort of change. Maybe the change is an entirely new career field. Maybe the change is adapting to the ever improving features of a… Read more

1 comments, 2,113 reads

Posted in SQL RNNR on 13 November 2018

Audit Database Offline Events

Knowing when an event occurred within the database environment is a very important thing. Being able to act quickly when certain events occur is equally as important. Sometimes, we may not find out about an event for a few days or weeks and then we are asked to figure out… Read more

0 comments, 232 reads

Posted in SQL RNNR on 13 November 2018

Refresh SQL Modules

As is true in most facets of life, things tend to get stale and old. Sometimes this staleness can be visibly represented as the wrinkles on your face. Other times, as with SQL Server, it may mean that a stored procedure or view stops working.

Unfortunately, when it comes to… Read more

0 comments, 777 reads

Posted in SQL RNNR on 9 November 2018

Cannot Use the Special Principal – Back to Basics

I recently had a client call me out of the blue because he happened to be getting an error while trying to add a user to a database role. The error he was getting was “Cannot use the special principal ‘dbo’.”

This error has probably cropped up on me more… Read more

0 comments, 2,554 reads

Posted in SQL RNNR on 7 November 2018