New Youtube Channel
Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...
2020-01-31
18 reads
New Youtube Channel
Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...
2020-01-31
50 reads
Finding Foreign Key Child Records In SQL Server
Foreign keys help to ensure referential integrity between tables. In other words, parent records cannot be deleted if there are child records present. This is a great thing and...
2021-05-03 (first published: 2020-01-31)
535 reads
Part 3 : Does data archival strategy matters ?
This article is the part of Does it matter ? series.
We'll discuss various aspects to save cost and optimize the database performance by archiving the data.
2020-01-31
40 reads
ASF 028: Uwe Ricken interview
Introduction Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of...
2020-01-31
11 reads
ASF 028: Uwe Ricken interview
Introduction Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of...
2020-01-31
5 reads
Your SQL Server's Screaming But Is Anyone Listening? – High Severity Alert Notifications
As usual, the scripts in this post can be found HERE on our Git Hub repo If your SQL Server comes across something that it’s not happy about, it...
2020-01-30
312 reads
Parameterizing a REST API Linked Service in Data Factory
We can now pass dynamic values to linked services at run time in Data Factory. This enables us to do things like connecting to different databases on the same...
2020-02-05 (first published: 2020-01-30)
1,214 reads
AWS RDS SQL Server Announcements - 2019
AWS RDS SQL Server Announcements - 2019
1. Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/
2. Amazon RDS SQL Server now supports logs to cloudwatch: https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/
3. Amazon RDS SQL...
2020-01-29
13 reads
AWS RDS SQL Server Announcements - 2019
1. Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/
2. Amazon RDS SQL Server now supports logs to cloudwatch: https://aws.amazon.com/about-aws/whats-new/2019/11/now-publish-log-files-amazon-rds-sql-server-amazon-cloudwatch/
3. Amazon RDS SQL Server now supports high availability in...
2020-01-29
432 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers