Today is Labor Day in the US, and a federal holiday. Not much of one for me as I'm flying to the UK today for a week of meetings and the Redgate Community Hub livestream on Wednesday. Register, tune in and watch if you can. I don't feel too bad about working today as I've had a few light days in the last few weeks.
When I was younger, Labor day was the end of summer. School typically started the next day, so this was our last day to go to the beach and surf, play volleyball, or enjoy ourselves with few responsibilities. It was the last day off for quite some time, usually until late October or even Thanksgiving in November. We appreciated this holidays as only schoolchildren can.
These days I view the world differently. Labor Day often means the start of conference season, with deadlines approaching and travel ramping up. So many events seem to occur in the Sept/Oct/Nov timeframe that it's a busy part of my year. This year is no different with travel this week and 4 more events before December. Hopefully I'll meet more of you at one of those stops.
Most of us are the laborers, working for an organization and receiving a paycheck in response. We don't usually have organized unions in our industry, but we have helped spur economic growth in our countries with our with in technology and this is a good day to remember our contributions and celebrate them in the US.
Write, format, and refactor SQL effortlessly with SQL Prompt
Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with tab coloring you’ll never deploy to the wrong environment again. Download your free trial
How to track every change to your SQL Server database
See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more
One of the new features of SQL Server 2016 is the ability to time travel in your databases and visit a specific table at a specific point of time in history. You can also use this feature to audit changes or “undo” whole data warehouse updates. More »
In this article, Grant Fritchey looks at the need to ‘shift left’ the database and associated database testing, while keeping sensitive data secure when it is outside the production environment. More »
This book shows how to deliver eye-catching Business Intelligence with Microsoft Power BI Desktop. You can now take data from virtually any source and use it to produce stunning dashboards and compelling reports that will seize your audience’s attention. Slice and dice the data with remarkable ease then add metrics and KPIs to project the insights that create your competitive advantage.
Yesterday's Question of the Day
(by Steve Jones):
What is a Table Valued Constructor?
Answer: A VALUES clause with multiple rows
A TVC is a VALUES caluse that contains a set of rows which act as a table.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.