Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Login from an Untrusted Domain – Back to Basics

Remember When…

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

I… Read more

0 comments, 94 reads

Posted in SQL RNNR on 8 November 2016

Finding Deprecated Uses in SQL Server

 

How well do you know your environment? You probably know all of the jobs that are running, the frequency that indexes need to be rebuilt, and even which users have which level of access to each object in the SQL Server instance. Do you know that your applications are… Read more

0 comments, 809 reads

Posted in SQL RNNR on 7 November 2016

Seattle SQL Pro Workshop 2016

Seattle SQL Pro Workshop 2016

You may be aware of an event that some friends and I are putting together during the week

of PASS Summit 2016. I have listed the event details within the EventBrite page here.

As we near the actual event, I really need to get… Read more

0 comments, 205 reads

Posted in SQL RNNR on 24 October 2016

Database Dropped

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… Read more

2 comments, 1,209 reads

Posted in SQL RNNR on 9 September 2016

Default Sessions – Back to Basics

Remember When…

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

I… Read more

0 comments, 2,048 reads

Posted in SQL RNNR on 1 September 2016

Events By Feature

Within the world of SQL Server there are a few things one can be certain of – things will change. This is true of the features in SQL Server. Additionally, Extended Events is constantly evolving which underscores this constant change.

With all of this change occurring within SQL Server, sometimes… Read more

0 comments, 215 reads

Posted in SQL RNNR on 30 August 2016

Finding the Right Path

I have a fairly large backlog of articles that are in progress or that are planned for my series about Extended Events. Despite the backlog and planned articles, every now and then something else comes up that bumps things around. This article is an example of bumping the schedule around.… Read more

0 comments, 1,090 reads

Posted in SQL RNNR on 24 August 2016

T-SQL Tuesday #081: Recap

Sharpen Something

In case you missed it (many did), TSQL Tuesday was a challenging event this month. I invited people to do a put a little more into writing a post than what they may usually do. There were some very good reasons for this. If you are interested, take… Read more

4 comments, 114 reads

Posted in SQL RNNR on 18 August 2016

T-SQL Tuesday #081: Getting Sharper

Sharpen Something

This month I am the host of the TSQL Tuesday blog party. In the invite, which can be read here, I asked people to decide on something to work on, plan out and then report the success/failure.

Not only am I the host, but I am a… Read more

0 comments, 55 reads

Posted in SQL RNNR on 16 August 2016

Audit All Select Statements

Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required that queries be audited and tracked to reach compliance with the legislation or regulation. To achieve this compliance, this article will demonstrate how to use Extended Events to audit statements… Read more

4 comments, 2,123 reads

Posted in SQL RNNR on 8 August 2016

BIT9 PathNames

We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news. In our quest to improve security we seemingly always find more and more products that are supposed to help with that security. Sometimes, those products require a data… Read more

4 comments, 324 reads

Posted in SQL RNNR on 5 August 2016

T-SQL Tuesday #081: Sharpen Something – Reminder

Sharpen Something

Last week I sent out the invite for the August TSQL Tuesday blog party. In that invite I promised to send out a reminder seven days prior to the event. Well – it is that time.

You are cordially invited to read the invite for TSQL Tuesday 81 Read more

0 comments, 1,070 reads

Posted in SQL RNNR on 2 August 2016

Easily Shred Event Data

It has been nearly a year since I started an extensive series about Extended Events. Previous to that start, I had already written a bunch of articles about Extended Events.

Among the batch of articles preceding the 60 day series one can find an article about shredding extended event data.… Read more

6 comments, 1,273 reads

Posted in SQL RNNR on 1 August 2016

T-SQL Tuesday #081: Sharpen Something

Sharpen Something

It has now been 30 months since the last time I hosted a TSQL Tuesday, that was TSQL Tuesday 51. I recapped that event here with the original invite here. I can’t believe it has been that long since I last hosted. It only seems like yesterday. Read more

10 comments, 266 reads

Posted in SQL RNNR on 27 July 2016

You Deserve to be an MVP

I have been sitting on this article for a while now. I have been tossing around some
thoughts and finally it is time to share some of those thoughts with the masses. I hope to provoke further thought on the topic of being an MVP.

I want to preface all… Read more

2 comments, 217 reads

Posted in SQL RNNR on 25 July 2016

Another Query to Help Find the Right Event

Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events. In this follow-up article to Extended Event Help Queries, I will share another means to quickly explore the… Read more

3 comments, 1,255 reads

Posted in SQL RNNR on 21 July 2016

Extended Event Help Queries

Enjoy this article re-publication from my original work at SQL Solutions Group.

When working with Extended Events, there are times when a little more information is, well, helpful.  You know you want to use extended events to try and monitor for a specific thing to happen.  But sometimes you don’t… Read more

1 comments, 390 reads

Posted in SQL RNNR on 19 July 2016

SQL Server CTE – Back to Basics

Quick Flashback

Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a blog post each month on a SQL Server Basic. Some have hash-tagged this as #backtobasics. Here is the link to that challenge sent via tweet.

I… Read more

2 comments, 2,854 reads

Posted in SQL RNNR on 14 July 2016

SQL Server Desired Enhancements

Happy Belated Birthday

The monthly Data Professionals blog party has come and gone. It happens the second Tuesday of every month – or at least is supposed to happen on that day. This month, the formidable Chris Yates (blog | twitter) has invited everybody to a birthday party Read more

4 comments, 234 reads

Posted in SQL RNNR on 13 July 2016

Awesome SQL Server Feature

The second Tuesday of April 2016 is now upon us and you know what that means. Well, I hope you know what that means.

It is time for TSQL Tuesday. It is now the 77th edition of this monthly blog party. This month the host is Jens Vestergaard (blog Read more

2 comments, 276 reads

Posted in SQL RNNR on 13 April 2016

Older posts