Pro SQL Server 2022 Wait Statistics Book
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
4M ago
After many months of editing, revising, and writing, my new book Pro SQL Server 2022 Wait Statistics: A Practical Guide to Analyzing Performance in SQL Server and Azure SQL Database is ready for print! You can pre-order here: https://amzn.to/3fQr7hz I thoroughly enjoyed this project, and I want to thank Apress and Jonathan Gennick for giving me the opportunity to update the previous edition. It felt good to be writing again, something I have not been doing enough of lately. And many thanks to Enrico van de Laar (@evdlaar) for giving me amazing content to start with. The book is an effort to h ..read more
Visit website
Stop Using Production Data For Development
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
1y ago
A common software development practice is to take data from a production system and restore it to a different environment, often called “test”, “development”, “staging”, or even “QA”. This allows for support teams to troubleshoot issues without making changes to the true production environment. It also allows for development teams to build new versions and features of existing products in a non-production environment. Using production to refresh development is just one of those things everyone accepts and does, without question. Of course the idea of testing in a non-production environment isn ..read more
Visit website
Microsoft Data Platform MVP – A Baker’s Dozen
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
1y ago
No Satya, thank you. And you’re welcome. Let’s do lunch next time I’m in town. This past week I received another care package from Satya Nadella. Inside was my Microsoft Data Platform MVP award for 2021-2022. I am happy, honored, and humbled to receive the Microsoft Data Platform MVP award for the thirteenth straight year. I still recall my first MVP award and how it got caught in the company spam folder. Good times. I am not able to explain why I am considered an MVP and others are not. I have no idea what it takes to be an MVP. And neither does anyone else. Well, maybe Mi ..read more
Visit website
Twenty Years
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
1y ago
My life changed twenty years ago, this very month. I was a developer, working for a small software company outside of Boston. Our product was a warehouse management system, built with PowerBuilder on top of Oracle. We had a handful of large customers helping to keep the lights on, but a few went dark at the start of the year, casualties of the dot-com bust.  We were soon a casualty as well, forced to sell to a competitor at the start of the year. And despite their promises and assurances about not making changes, the layoffs started within the first few months.  They hit about a doze ..read more
Visit website
Twenty Years
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
1y ago
My life changed twenty years ago, this very month. I was a developer, working for a small software company outside of Boston. Our product was a warehouse management system, built with PowerBuilder on top of Oracle. We had a handful of large customers helping to keep the lights on, but a few went dark at the start of the year, casualties of the dot-com bust.  We were soon a casualty as well, forced to sell to a competitor at the start of the year. And despite their promises and assurances about not making changes, the layoffs started within the first few months.  They hit about a doze ..read more
Visit website
SET NOCOUNT For SQL Server
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
2y ago
Last week I was reviewing an article and found myself needing information on the use of NOCOUNT as a standard for writing stored procedures. A quick internet search found this old post of mine, written back when I used to work for a living. Apparently, I was once asked to enable NOCOUNT for a specific SQL Server database. As the post suggests, this is not possible. The options for NOCOUNT are to set for the entire instance, for your specific connection, or within your T-SQL code. Since the post was written well before the new-ish ALTER DATABASE SCOPED CONFIGURATION statement, I was hopeful ena ..read more
Visit website
The Most Important Feature in Microsoft Teams You Aren’t Using
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
2y ago
It’s been a year, people. A full year of remote meetings. And honestly, it’s as if you have learned nothing in that time. Remote meetings have a different dynamic that in-person meetings. I was hopeful the past year you would all come to understand this and adjust your habits accordingly.  Well, I’m not afraid to admit I was wrong. None of you have learned a damn thing. You treat remote meetings as if they are in person. You jump at the chance to speak, just as a half dozen other people are speaking.  I am here today to make some suggestions.  First, a meeting should have an age ..read more
Visit website
You Can’t Marry Your Database, But You Can Have Relations
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
2y ago
There’s something you should know about relational databases. They were designed to store data efficiently, protecting the quality of the data written and stored to disk. I’ve written before about relational engines favoring data quality and integrity, and how relational databases were not designed for the reading of data. Of course, if you are going through the trouble of writing the data into a relational database, it makes sense that you would want to retrieve the data at some point. Otherwise, why go through the exercise of storing the data inside the database? The trouble w ..read more
Visit website
Create and Use an Email Alias
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
2y ago
At this point I believe we all have a “burner” email account or two. An email account we use when an email address is required from us, but we do not trust the person making the request. In addition to using email accounts that are 20+ years old, we can also create and use an email alias. Using an alias gives us more flexibility, allowing for us to track any misuse of our data. If you are using Office Microsoft 365, you can create and use an email alias through your admin center. Navigate to your username and click ‘Manage username and email’. In the blade that opens you can add your alias. I ..read more
Visit website
Book Review: Calling Bullshit
Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar
by Thomas LaRock
2y ago
Each year, I try to find a good book to bring with me to the beach. A few months ago, I came across Calling Bullshit: The Art of Skepticism in a Data-Driven World while doom scrolling Twitter one night. I ordered the book and did not wait for the beach to get started reading. Written by Carl Bergstrom and Jevin West, Calling Bullshit is their effort at helping everyone develop the necessary skills for critical thinking. The book reads as if you were following a college lecture. And this makes sense, since the authors are professors at the University of Washington in Seattle. You can see the co ..read more
Visit website

Follow Thomas LaRock - Author, Speaker, Data Expert, and SQLRockstar on Feedspot

Continue with Google
OR