Latest Blog Posts
On May 2, 2017, I’ll be giving two talks at the SSWUG 2017 Virtual Conference. Here are the talks:
Building a Home Grown Auditing Infrastructure for SQL Server
Not everyone has the budget for 3rd party tools to provide audit / security information on their SQL Server environment.… Read more
You could win an Amazon Echo from Redgate. Our contest is still open for a few days, so post a comment on my blog and take your chances. I’ll be picking from the comments next week.
Filed under: Blog Tagged: Redgate, SQL Clone, syndicated
I was chatting on the SQL Community Slack with my friend Sander Stad b | t about some functions he is writing for the amazing PowerShell SQL Server Community module dbatools. He was asking my opinion as to how to enable user choice or options for Agent Schedules and… Read more
Sometimes we, as data professionals, have to think outside the box. I know, crazy idea right? Each shop and situation are different; there will always be several different ways in most cases that you can arrive at a solid solution.
This post has a few intentions behind it:
Cue Princess Jasmine.
What do I mean “Cue Princess Jasmine”?
Well because starting today, it’s a “Whole New World for You & Me”
What on Earth am I talking about??
The SqlServer PowerShell is now available for download in the PowerShell Gallery! http://sqlps.io/sqlserver
What Does It Mean!?
It means that… Read more
I had this question come up at work the other day and while I knew it was true I wasn’t as sure about why as I’d like. The person I was working with wanted a real answer, not just Because I say so, so off to the internet I… Read more
Last week Microsoft confirmed that the name of SQL vNext will indeed be SQL Server 2017. I was looking through the documentation for more info on Adaptive Query Processing as I wanted to write a post on adaptive joins but then I saw: –
To see the new Adaptive Join… Read more
This one is for the DacFx nuts out there, it can't be a very big club but judging from the occasional emails I get about it, the quality is very high ha ha.
If you have a TSqlModel and you want to make a change to it, you have a…
On May 3, 2017, at 2 PM EDT (6 PM GMT) I’ll be speaking as part of the 24 Hours of PASS. Here’s what I’ll be speaking on:
Protecting Data Across the Environment
You are responsible for protecting data within your organization. Wary of how attackers have become… Read more
In this module you will learn how to use the Time Brush Power BI Custom Visual. The Time Brush gives you the ability both filter your report and see a graphics representation of your data at the same time. The name Time Brush comes from the behavior used when you… Read more
I like scripts. Scripts that help me do things.
Working in the financial industry, there are always things that you have to ensure are protected. More specifically, social security number and date of birth.
If your environment is like most, there are legacy applications that have a database behind the… Read more
“One of the advantages of being disorderly is that one is constantly making exciting discoveries.” While this quote is true it is often times too late to act on an opportunity therefore it is missed. If you are a leader at your respective shop it can then be conceived that… Read more
This summer, I will be delivering my popular full-day training class Building Better SSIS Packages in three different cities across the southern United States: Thursday, June 1st: Pensacola, Florida Friday, June 16th: Pasadena, Texas (just outside of Houston) Friday, July 14th: Lawrenceville, Georgia (near Atlanta) This course is designed for… Read more
I was asked, “Who here thinks that PASS helps people put food on the table?” To my shame, I initially said no. I mean after all, it’s just training and networking that could lead to improved knowledge and abilities which… hang on. Just how wrong I can be sometimes when… Read more
A teams maturity shows in its choice of tools.
I have seen quite a few different development teams in wildly different environments and the single fact that really stands out is that you can tell how good a team is by the tools that they use. It isn't always the…
I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does at dinner. As we talked about it, I suddenly thought about both Plan Guides and the Query Store. I wondered what happened to the query hash values in that case?… Read more
When you right click on a tab you’ll see a number of different options. You can set up new horizontal or vertical tab groups, pin tabs, close tabs etc. But in this particular case take a look at these options.
- Copy Full Path
- Open Containing Folder
They… Read more