My Preferences for SSIS Design
Lately, I have been using SSIS execution frameworks and Biml created by other people to populate data marts and data warehouses. It has taught me a few things and...
2019-08-20 (first published: 2019-08-08)
1,164 reads
Blog Posts
5 Things You Need To Know When Reading SQL Server Execution Plans
Watch this week’s episode on YouTube. 5 Things You Need To Know When Reading SQL Server Execution Plans In the first part of this series I explained what an execution...
2019-08-19 (first published: 2019-08-06)
1,310 reads
Azure DevOps: How to Set a Custom Release Branch Folder Filter in Build Pipeline Triggers (video)
This is the first in a series of posts about simple things that I had a hard time figuring out in Azure DevOps services. It can be very useful...
2019-08-19
56 reads
Beginning T-SQL and Career Roadmap for Women (and Men)! #SQLSatBR
Download session materials and watch the recordings of my excellent sessions on Transact-SQL and IT careers! I'm looking especially at you, women in technology!
The post Beginning T-SQL and Career...
2019-08-19
30 reads
Feature Restrictions in SQL Server 2019 are Worse Than Useless: a False Sense of Security And Wasted Opportunity
A misguided attempt to improve security that not only increases the chances of SQL Injection, but also prevented useful changes from being made.… Continue reading Feature Restrictions in...
2019-08-19 (first published: 2019-08-05)
1,294 reads
A simple Machine Learning process example (supervised) – just to start with
I have just written the fifth article of the Machine Learning topic. !!! This time it is an example of the process – step by step. Do not miss...
2019-08-17
56 reads
Always On: Troubleshooting Consolidated
Working on Always On and configuration/setup of AG we have observed many errors. especially when configuration listener with following error 19471 or AG could not configure: Creating availability group...
2019-08-17
51 reads
Changing Git Credentials in Windows
tl;dr For Windows when you need a different account. I had to work with a new GitHub account recently and needed to add a separate account. I worked through...
2019-08-16
7,364 reads
Copy Files to a Docker Container
One of the things that’s handy when working with containers is being able to move files in and out of the container. Certainly you can do this from a...
2019-08-16 (first published: 2019-07-31)
406 reads
SQL Homework – August 2019 – Getting the data out
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-08-16 (first published: 2019-08-05)
325 reads
Blogs
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
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