Azure SQL Database Automatic Tuning
I really like the automatic tuning aspect of Azure SQL Database. This post is not a full explanation and demo. Instead, I want to point out a small point...
2020-08-27 (first published: 2020-08-17)
258 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
My First Hand-built AWS CodePipeline
I’ve just completed my first, successful, AWS CodePipeline. I’m sorry to say it took me weeks to figure out just how simple this was. Frankly, it’s embarrassing. I already...
2020-08-19 (first published: 2020-08-10)
323 reads
Capturing Queries Can Be a Pain
The moment you decide you want to monitor your SQL Server instance for query behavior, you’re going to be forced to make a bunch of choices. Further, all these...
2020-08-11 (first published: 2020-08-03)
439 reads
Database Fundamentals #28: Creating a Primary Key Using T-SQL
There are actually a couple of ways to create a primary key with T-SQL. You can use the ALTER TABLE script to add a primary key to an existing...
2020-08-06 (first published: 2020-07-28)
524 reads
2020-08-01
117 reads
Announcing: AWS Community Builders
I’m excited to be able to announce that the AWS Community Builders, a new program for those who help out with AWS technologies, has been launched. You can read...
2020-07-30
14 reads
AWS Deployment Pipelines
I’m at the just barely scratching the surface level of getting started with AWS Deployment Pipelines. Of course, the first thing I want to do with them is get...
2020-07-20
62 reads
Database Fundamentals #27: Creating a Primary Key in the Table Designer
Defining primary keys is the hardest part of the operation. You will need to work very closely with the business in order to define exactly what column or columns...
2020-07-20 (first published: 2020-07-14)
343 reads
Do More, With Less
Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is our smaller, focused sessions. This one is about the concept of how DevOps, or, more...
2020-07-16
44 reads
Extended Events Capturing the T-SQL of Prepared Statements
I asked this question myself: Is there a way to use Extended Events to capture the T-SQL of a prepared statement? Why would I be concerned with prepared statements?...
2020-07-15 (first published: 2020-07-06)
340 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Prapen No.Tlp.083179431643
Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
BCA KCU MATRAMAN Tlp (+62 821°3111°179
Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah Khusus...
BCA Finance WTC Mangga Dua Tlp ( +62851°8812°0691
BCA Finance WTC Mangga Dua Hubungi/CS:.085188120691Tlp ( +62851°8812°0691 Gedung WTC Jl. Mangga Dua Raya....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers