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

T-SQL Tuesday #097: Learning Plans

Stylishly Late

I am fabulously late and therefor breaking the guiding rules that make up TSQLTuesday. Where’s the ruler to slap my fingers as I blatantly type this post so late?

Well, I did ask for a special pardon from the host this month. My friend Mala Mahadevan (blog Read more

0 comments, 28 reads

Posted in SQL RNNR on 18 December 2017

Incorrect Syntax – What?

Intuitive errors are very helpful when trying to troubleshoot a problem. On the other hand, when we receive an error that is vague, we sometimes find ourselves wanting to throw the laptop out the window. What do we do though when the error message really does look to be pretty… Read more

0 comments, 146 reads

Posted in SQL RNNR on 17 November 2017

T-SQL Tuesday #096: Inspiration Abounds

Who Inspires You?

Today is a bit of a divergence from the usual geekery that may abound on my blog. As prompted by Ewald Cress (blog | twitter), it is time to take a step back and put forth a bit of reflection. Ewald has requested we do… Read more

2 comments, 224 reads

Posted in SQL RNNR on 15 November 2017

SQL Server Haunt 2017

Halloween is a great time of year. It is unfortunate that it is just one day of the year. That said, I do like to think of the month of October as Halloween Month. I have several posts over the years that geek out over the cross-over between Halloween and… Read more

0 comments, 226 reads

Posted in SQL RNNR on 1 November 2017

What’s that SSIS Password

A recurring theme over the past several weeks (there are always recurring themes it seems) has been an issue that relates to SSIS. Clients will call for help with an SSIS package that has started failing and they are stuck trying to figure it out. They are all stuck at… Read more

0 comments, 641 reads

Posted in SQL RNNR on 30 October 2017

Drop That Schema

An often under utilized or maybe even mis-utilized feature of SQL Server is a database object schema. In the event of the latter, there is an occasional requirement for change. When this need arises, it can turn into a bit of a problem. That is of course if we are… Read more

0 comments, 1,740 reads

Posted in SQL RNNR on 27 October 2017

Seattle SQL Pro Workshop 2017 Schedule

Seattle SQL Pro Workshop 2017

You may be aware of an event that some friends and I are putting together during the week of PASS Summit 2017. I have created an Eventbrite page with all the gory details here.

With everybody being in a mad scramble to get things… Read more

0 comments, 249 reads

Posted in SQL RNNR on 26 October 2017

Seattle SQL Pro Workshop 2017

Seattle SQL Pro Workshop 2017

October is a great time of year for the SQL Server and Data professional. There are several conferences but the biggest happens to be in the Emerald City – Seattle

Some friends and I have come together the past few years to put on… Read more

0 comments, 852 reads

Posted in SQL RNNR on 19 October 2017

Linked Servers and Stats

Linked Servers

A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for the use of linked servers. Unfortunately, some are of the belief that a linked server is the solution to… Read more

0 comments, 509 reads

Posted in SQL RNNR on 17 October 2017

Your Name is Your Brand

This topic is one that has been stewing for a while and finally this week it decided to boil over.

My first thought with this post was to write a rant. Instead, I want to try and turn it on its end and try to put a different spin on… Read more

3 comments, 253 reads

Posted in SQL RNNR on 13 October 2017

Endpoint Owners – 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.

While… Read more

0 comments, 245 reads

Posted in SQL RNNR on 5 June 2017

SSRS Subscription Schedules – Enhanced

Reporting Services

 

Over the past couple of articles I have illustrated some of the fun that can be had when dealing with the scheduling capabilities of Reporting Services (SSRS). The first article covered how to create more advanced schedules (from the SSRS point of view). In another I article,… Read more

0 comments, 426 reads

Posted in SQL RNNR on 25 May 2017

SSRS Subscription Schedules

Reporting Services

Reporting Services (SSRS) is a tool that permits you to create and deliver feature rich reports. The reports can be delivered in various formats and can even be scheduled to be delivered at various times. I even recently wrote about creating more advanced custom schedules.

With the ability… Read more

0 comments, 1,741 reads

Posted in SQL RNNR on 23 May 2017

SSRS Custom Shared Schedule

Reporting Services

 

Reporting Services is a pretty feature rich tool for delivering reports to various consumers. There is plenty of power within Reporting Services (SSRS) giving one the ability to perform visualizations, render reports in various formats and even schedule reports to be delivered in different formats or on… Read more

0 comments, 1,588 reads

Posted in SQL RNNR on 22 May 2017

T-SQL Tuesday #089: The Cloud and Job Security

The Cloud

Today I am doing a quick entry for my participation points in the monthly blog party called TSQL Tuesday. I have missed the past few opportunities for various reasons. Today when I saw the topic, I wanted to post a few quick thoughts. If you are interested, the… Read more

0 comments, 423 reads

Posted in SQL RNNR on 12 April 2017

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, 2,358 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, 827 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, 459 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, 567 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,824 reads

Posted in SQL RNNR on 23 December 2016

Older posts