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

Database Backup History – 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, 401 reads

Posted in SQL RNNR on 20 December 2016

Last Restore of a Database – 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, 333 reads

Posted in SQL RNNR on 20 December 2016

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, 301 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, 1,151 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, 402 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,436 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,257 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, 470 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,300 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, 262 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, 205 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,377 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, 525 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,254 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

8 comments, 1,656 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, 565 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, 383 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,422 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, 509 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, 3,119 reads

Posted in SQL RNNR on 14 July 2016

Newer posts

Older posts