Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.
A Comparison of Database Drivers for MySQL
MySQL is "The world's most popular open source database" and it is widely-used to store and access your data. In fact, there are many cloud and on-premise databases (like MemSQL and Google Cloud SQL) that use the MySQL interface. Several native, open-source drivers are available for connecting to your MySQL data from other applications. In […]
The Complexity of Modern Systems
Building software is hard, and our systems are very complex these days.
Working with an Azure Data Factory Meta-data Driven Pipeline
This article shows how to create a data driven ADF pipeline.
Learn how to use Flyway for Automated Database Migrations
Here's your one-stop-shop for Flyway learning resources, curated by Tony Davis. Check out this handy learning pathway for managing and automating database deployments, from version control, using Flyway.
Ransomware: A world under threat
Ransomware has threatened many organizations over the past few years. In this article, Robert Sheldon explains the history of ransomware and what needs to be done to protect against it.
PASS Data Community Summit 2021 Report
The 2021 virtual PASS Data Community Summit was held from November 8th through the 12th. PASS Summit has always been the biggest yearly conference for database professionals, and this year’s virtual conference had over 18,000 individuals registered! If you signed up for the event, you may now stream the sessions on-demand. This is an exclusive […]
SQLFacts - A Free Toolkit for SQL Server Database Engineers
SQLFacts is a FREE suite of 26 (and counting) tools for SQL Server database development, database administration, and performance tuning. The toolkit is all T-SQL code and it includes the functionality of hundreds of short scripts.
Where is the Puck Going?
In which direction should you drive your career? Steve has a few thoughts today.
CRUD Operations on a SharePoint List using Python
This article explains which Python library provides create, read, update, and delete (CRUD) operations on a SharePoint list along with examples.
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers