Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
Please Vote for my article "SQL Triggers - An Introduction" on CodeProject.
One of my Code Project article on SQL Trigger has...
2019-01-09
302 reads
BIOS and OS Power Settings to enhance SQL Server Performance
Performance is always a most prioritized task for any DBA and every DBA always prefer to go for a proactive...
2019-01-09
1,567 reads
A Monumental Migration to SQL Server 2016 - Part 2
In my previous post, I outlined the preparations we undertook to migrate a large SQL Server 2008R2 instance to SQL Server 2016. This post details migration day.
Final Prep We...
2019-01-09
26 reads
Automating like an Enterprise DBA
One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing....
2019-01-08
21 reads
Automating like an Enterprise DBA
TSQL Tuesday
The second Tuesday of the month comes to us a little early this month. That means it is time...
2019-01-08
674 reads
Point In Time Restore for Azure SQL Database
Point In Time Restore for Azure SQL Database
This article try to explain
Automatic backups services provided by Azure
Backup retention periods
How to take the point in time database restoration
This database restoration...
2019-01-08
55 reads
Point In Time Restore for Azure SQL Database
Point In Time Restore for Azure SQL Database
This article try to explainAutomatic backups services provided by Azure Backup retention periodsHow to...
2019-01-08
190 reads
T-SQL Tuesday #110 – Automate All the Things
From a DBA's perspective, automation is something that is absolutely necessary. This post shows just a few areas where I use automation in my life.
The post T-SQL Tuesday #110...
2019-01-08
20 reads
T-SQL Tuesday #110 – Automate All the Things
Automate All the Things
I had a strange thing happen to me this week. My IFTTT applet that sends me an...
2019-01-08
191 reads
Speaking at SQLSaturday Nashville – 815!
Speaking at SQLSaturday Nashville – 815!
I’m proud to announce that I will be speaking at SQL Saturday Nashvilleon January 12th 2019! And wow, 815 SQL Saturdays! This one won’t let you...
2019-01-08
13 reads
Blogs
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Alamat BCA KCP City Center Hub/Wa. 0817-819-444
WhatsApp:0817819444 Kawasan Terpadu The City Center, Gedung Perkantoran Tower One, Ground Floor, Jl. K.H....
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers