Latest Blog Posts
My new course “LFCE: Advanced Linux Networking” in now available on Pluralsight here!
This course targets IT professionals that design and maintain RHEL based enterprises. It aligns with the Linux Foundation Certified System Administrator (LFCS) and Linux Foundation Certified Engineer (LFCE) and also Redhat’s RHCSA and RHCE Read more
The Future of SQLPSX
Make sure you have a working version of SQL Server 2016.
/****** Object: Database [WorldHealth] ******/
CREATE DATABASE [WorldHealth]
CONTAINMENT = NONE
( NAME = N’WorldHealth’, FILENAME = N’D:\Microsoft SQL Server\DATA\WorldHealth.mdf’ , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
LOG ON Read more
This past weekend was the first SQL Saturday in San Antonio, TX. I was lucky enough to get the chance to go, and I was happy to do so. I like to support new events in new cities, and hopefully I can help keep them going in the future.
I… Read more
I love the Query Store. Seriously. It’s a huge leap forward in the capabilities of Azure SQL Database and SQL Server in support of performance monitoring and query optimization. One of my favorite aspects of the Query Store is the ability to force plans. Frankly though, it’s also the scariest… Read more
Possibly the single most influential event in my career happened over 25 years ago. I lost my temper at a client.
The client had requested a meeting. They had a new, complex, system they wanted implemented in the software we managed for them. The client was very very excited. I… Read more
Did some checking as couldn't find help in the MSDN documentation. My test on SQL 2016 shows that since the column_id isn't changing, the existing mapping of the description for the column is preserved.
I know it's probably pretty obvious, but I had someone ask me, so figured proving the… Read more
This weekend, I attended SQLSaturday in Indianapolis for the first time. It’s one of the larger events in the Midwest and I’ve tried to schedule it for several years, but it’s always fallen on a weekend when I couldn’t attend. This year, the date finally worked out!
My presentation for… Read more
Microsoft released a new sample database a couple of months back: Wide World Importers. It’s quite great: not every (unnecessary feature) is included but only features you’d actually use, lots of sample scripts are provided and – most importantly – you can generate data until the current date. One… Read more
This past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held at Indiana Wesleyan. Most of you who end up on this site are probably familiar with it, but for those that aren’t familiar with SQL Saturday events you… Read more
Having a cloud you can trust is important. Microsoft takes security and compliance extremely seriously in both the commercial and government clouds. An August 2016 article on the Azure blog, Not All Clouds Are Created Equal, addressed this topic in detail discussing the impact of a CJIS compliant cloud… Read more
One of the top three performance killers for SQL Server is lack of processing power. I’d say that it’s second only to storage latency and more of a concern than memory. Although with anything in SQL we can say it depends.
I’ve recently seen a lot of SQL Server instances… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
This is an easy one, but you’ll want to try this yourself.
As I’ve been trying to move off the various SSMS versions I have installed to… Read more
Yep, that’s right, you heard me. Write-Only not Read-Only. I was presenting SQL Server Security Basics at NTSSUG the other night and there was an interesting discussion on the idea of granting someone write permissions without corresponding read permissions.
So for example:
-- Setup code CREATE LOGIN WriteOnlyUser WITH…
In the context of my developer machine, I had log files I wanted to parse through. I setup a log library to output the results on a test server to a sql table instead of text files. However, this meant that my "log viewers" that handled regex parsing weren't in… Read more
I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW). The most important thing to remember is SQL DB is for OLTP (i.e. applications with individual updates, inserts, and deletes) and SQL DW is not as it’s strictly for OLAP (i.e. data… Read more
One of the things I ran into a few years ago was the idea of a software pipeline. A set journey across machines and stages that your software takes. In modern, DevOps style development shops, this usually means:
- A development machine(s)
- A Version Control System (VCS)
- A CI/Build server/system