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

SQL Server Fixed Role Permissions

Roles and Permissions

Some of my recent articles have been focused on permissions and security. There is good reason for that – security is important and all too often it is mis-understood.

You can catch up with a couple of those articles here and here.

It is very important… Read more

1 comments, 1,521 reads

Posted in SQL RNNR on 6 March 2017

SQL Server Permissions – Database Roles

EZ PZ Permission Squeezee

Given the critical level of importance related to permissions, one may think it is a concept that is well understood by all who are given the charge of protecting the data.

There is a great responsibility when the keys to the data kingdom are granted to… Read more

0 comments, 358 reads

Posted in SQL RNNR on 2 March 2017

Parse Dynamics AX Context Info

Dynamics AX and SQL Server

More and more I am seeing clients requiring assistance with the Microsoft Dynamics Suite. Each of the products in the suite comes with a different set of performance issues and gotchas. In this article I will only be discussing the AX product and an easy… Read more

0 comments, 170 reads

Posted in SQL RNNR on 30 January 2017

User Contains Invalid Characters – 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, 227 reads

Posted in SQL RNNR on 24 December 2016

What Agent Job is Running – 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, 1,616 reads

Posted in SQL RNNR on 23 December 2016

Database Backups – 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, 394 reads

Posted in SQL RNNR on 22 December 2016

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, 233 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, 200 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, 159 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, 985 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, 269 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,281 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,114 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, 291 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,159 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, 162 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, 108 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,220 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, 376 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,128 reads

Posted in SQL RNNR on 2 August 2016

Older posts