The host for T-SQL Tuesday #79 is Michael J. Swart (b|t), and his topic of choice is to write about the new release of SQL Server 2016. This past weekend I attended the SQL Server 2016 Launch Discovery Day in Raleigh, NC. I have attended several SQL Server launch events over the years, but this one was quite different. While it wasn’t a real launch event, it was marketed as a hands-on event to learn about the newest release of SQL Server. The hands-on part for everyone to breakup into teams of five to solve a pre-determined problem. Basically, this was...
Continue reading...TSQL Tuesday
TSQL Tuesday #47 – Your Best SQL Server SWAG
The host for T-SQL Tuesday #47 is Kendal Van Dyke (blog|twitter), and his topic of choice is about the best SQL Server SWAG we ever received at a conference; specifically, the “good stuff”. I’ve been doing a lot of work with SQL Server over the years, but I’ve only had the opportunity to attend the big conferences a few times. As a matter of fact, next week will be my first time attending the SQL PASS Summit. We’re supposed to talk about the “good stuff” and not any of the “cheap tchotchkes” that are given away by the vendors, but...
Continue reading...T-SQL Tuesday #40 – Proportional Fill within a Filegroup
T-SQL Tuesday #40 is underway, and this month’s host is Jennifer McCown (blog|twitter). The topic is about File and Filegroup Wisdom. Jennifer says she’s a big fan of the basics, so I thought I would talk about the basics of proportional fill within a filegroup. This should be pretty common knowledge, but I still talk to a lot of DBAs that don’t know anything about it, or if they have heard of it, they still don’t know how it works. The proportional fill algorithm is used to keep the amount of free space within a filegroup evenly distributed across all...
Continue reading...T-SQL Tuesday #39 – Use Powershell to Restore a Database on a Different Server
T-SQL Tuesday – This month’s party is hosted by Wayne Sheffield (blog|twitter), and the topic is about Powershell and how to use it for anything SQL Server. With that challenge, I’d like to share a script I’ve written that takes a backup file from one server, copies to another server, and and then restores it. That may sound pretty easy, but I’ve added in a few requirements to the restore. Here’s the scenario: We have two SQL Servers, one production (TRON2R2PROD) and one test (TRON3R2TEST), and we have one user database (AdventureWorks2008R2) on each of the production and test servers. The...
Continue reading...
