General Purpose Tier for Azure SQL Database
Five years ago, there were a limited number of ways to deploy and use the SQL Server engine in the Azure Cloud. Today, there are many different services available.
2020-02-18
Additional Articles
Record responses for the State of Database DevOps report
The fourth annual State of Database DevOps report is now available for download. Kendra Little announces the launch in her latest blog. Check out the first high level findings of the report here.
2020-02-18
The Dangers of using Float or Real Datatypes
Floating point datatypes accommodate very big numbers but sacrifice precision. They are handy for some types of scientific calculations, but are dangerous when used more widely, because they can introduce big rounding errors.
2020-02-17
Using SQL Server RAND Function Deep Dive
Dr. Dallas Snider, a MSSQLTips author, mentioned that SQL Server RAND() function could generate random values uniformly distributed from 0 through 1, exclusive. He generated random numbers from the normal distribution with a specific mean and standard deviation.
2020-02-17
Checking for Database Events Using Extended Events and SQL Monitor
You need to make sure that nobody tampers with your production databases, or really any databases outside Development. Even if you weren't of a nervous disposition, you'd want to know if a database was stopped or removed. You'd also be intrigued by the sudden unrehearsed addition of a database to a production server.
2020-02-14
Simple DBCC CHECKDB process to report on database corruption for all SQL Server databases
As DBAs, we all know how important it is to check all of the SQL Server databases under our care for potential corruption issues. However, to accomplish that, we might not have the time to do any of the following:
2020-02-14
Managing SQL Server Docker containers in macOS
In the second article of this series, Carlos Robles explains how to manage Docker images and containers.
2020-02-13
Azure Data Factory Multiple File Load Example - Part 2
In this two-part tip, we are created a metadata-driven pipeline which will copy multiple flat files from Azure blob storage to an Azure SQL Database. The flat files can have different delimiters and are stored in different folders and there are multiple destination tables as well.
2020-02-12
Queue table issues with Availability Groups in SQL Server
I recently came across an issue in a SQL Server Availability Group scenario where queries against a heavily-used queue table were taking longer and longer over time.
2020-02-11
The Dangers of using Float or Real Datatypes
Floating point datatypes accommodate very big numbers but sacrifice precision. They are handy for some types of scientific calculations, but are dangerous when used more widely, because they can introduce big rounding errors.
2020-02-11
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 Raya Kuta - CCR Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Raya Kuta No.55X, Kuta, Kec. Kuta, Kabupaten Badung, Bali 80361
BCA KCU INDRAPURA No tlpon:083138717148
Whatsapp:083138717148.Jl. Indrapura No.35, Kemayoran, Kec. Krembangan, Surabaya, Jawa Timur 60176
BCA KCP Abdul Muis Telp:cs.(0821)8171955
Whatsapp:08218171955 Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101, Petojo...
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