Free Video: 300-Level Guide to Career Internals: Planning Your Career
Erika applies a mask to me at the Blue Lagoon Hi. I’m writing this from a cottage in Iceland, in the midst of a 9-month digital nomad stint. I’m teaching classes and doing client work for 1-2 weeks, then Erika and I take off and hit the roa …
Managing SQL Snippet Collections using JSON and PowerShell
The post Managing SQL Snippet Collections using JSON and PowerShell appeared first on SQLServerCentral.
SQL Server and hyperconvergence
A growing number of organizations have deployed hyperconverged infrastructure (HCI) systems in an effort to simplify IT operations, better utilize resources, and lower costs. They might house the systems in their own data centers, colocation facilities …
What does SET NOCOUNT ON do?
When you’re working with T-SQL, you’ll often see SET NOCOUNT ON at the beginning of stored procedures and triggers. What SET NCOUNT ON does is prevent the “1 row affected” messages from being returned for every operation. I …
Embed Power BI in Jupyter Notebooks
Microsoft recently announced the ability to include Power BI reports inside Jupyter notebooks. After overcoming the dazzle of this exciting feature, what comes to my mind is: “Why do we need this?” I’m far from being a Jupyter noteboo …
How Can Redgate Tools Help with a Cloud Migration?
The post How Can Redgate Tools Help with a Cloud Migration? appeared first on SQLServerCentral.
How to Find Unused Databases in SQL Server
The post How to Find Unused Databases in SQL Server appeared first on SQLServerCentral.
Introduction to generic Power BI themes
Power BI has taken the world by storm when it comes to creating attention-grabbing dashboards that empower users. It has come to dominate the analytics arena with its ease of use, wide range of connectivity options, and the variety of available visuals …
Download the Current Stack Overflow Database for Free (2021-06)
Stack Overflow, the place where most of your production code comes from, publicly exports their data every couple/few months. @TarynPivots (their DBA) tweets about it, and then I pull some levers and import the XML data dump into SQL Server format …
The four best features to look out for in SQL Monitor
The post The four best features to look out for in SQL Monitor appeared first on SQLServerCentral.
Simple Talk Storage 101 by Robert Sheldon
The post Simple Talk Storage 101 by Robert Sheldon appeared first on SQLServerCentral.
“I’m getting index seeks. Why are my row estimates still wrong?”
If you’ve got good indexes to support your query, and statistics to help SQL Server guess how many rows will come back, how can SQL Server still come up with terribly incorrect row estimates? To demonstrate, I’ll use the 2018-06 version of …
SQL Server Resource Governor Game
The post SQL Server Resource Governor Game appeared first on SQLServerCentral.
SQL Server transaction log architecture
The transaction log is a file that each SQL Server database has. It can be thought of as a journal of update activity that has occurred to a database. The transaction log is used to maintain the integrity of the database. The information stored about a …
How to Patch SQL Server
Microsoft releases SQL Server Cumulative Updates about every 60 days. This is a part of your job that you’re going to be doing a lot, so let’s get good at it! Here’s the strategy I like to use. Pick what patch you’re going to ap …