How DevOps can enable the evolving insurance landscape
The post How DevOps can enable the evolving insurance landscape appeared first on SQLServerCentral.
Move SQL Server Files for Master Database
The post Move SQL Server Files for Master Database appeared first on SQLServerCentral.
Azure Databricks Access Controls and Row Level Security
The post Azure Databricks Access Controls and Row Level Security appeared first on SQLServerCentral.
Branching and Merging in Database Development using Flyway
The post Branching and Merging in Database Development using Flyway appeared first on SQLServerCentral.
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.