Tag Archives: syndicated

Rebooting Ubuntu Linux from the Command Line–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Since SQL Server 2017 is now out, and Linux is an option, I thought I’d write a bit more … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Quick SQL Prompt Updates in a Pattern

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Using Backup-DbaDatabase for a Quick Backup

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

Getting the Random Module in SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today. I … Continue reading

Posted in Blog | Tagged , , | Leave a comment

WAITFOR isn’t a function–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I needed to delay the execution of some code the other day. This was a test that was trying … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Using xp_delete_file

First, this is an undocumented proc, and there’s nothing in BOL on this. Second, it’s a holdover from previous versions, so you’d be better served by using Powershell or some other type of scripting mechanism. This procedure is not supposed … Continue reading

Posted in Blog | Tagged , , | 2 Comments

Simplified Networking with a Wsky USB NIC

I used to share an office with my wife. We both needed Internet connections, with both desktops needing Ethernet cables. That was fine when my DSL router was in the office, but at some point we got a new provider … Continue reading

Posted in Blog | Tagged , | Leave a comment

Compound FKs with SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today. A … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Enabling Database Containment for an Instance – #SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. This is also a part of a basic series on git and how to use it. I wanted to … Continue reading

Posted in Blog | Tagged , , , , | Leave a comment

The New CU Schedule

Is my math right? The new CU servicing schedule for SQL Server 2017 is: 1 CU per month for the first year 1 CU per quarter through mainstream support (5 years) That means by my count, we get this: WITH … Continue reading

Posted in Blog | Tagged , , | Leave a comment