So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? Murilo Miranda provides a simple guide to get started.
Amateurs practice until they can get something right. Professionals practice until they don't get things wrong. How should we handle our deployments?
In many cases Azure SQL Database offers an economically and functionally viable alternative to SQL Server deployments. However, there are also scenarios where we might discover that rather than serving as a replacement, it provides synergy, working side by side with your on-premises databases. One of technologies that illustrate this paradigm is Stretch Database, introduced in SQL Server 2016. Marcin Polichtdescribes its basic characteristics and reviews its implementation steps in this article.
In this post, I’m going to talk an issue that I found when creating an availability group listener by using SQL Server Management Studio's Add Listener. This article helps you to resolve the issue.
Aaron Bertrand continues his series on widening an IDENTITY column, showing how he would attack the problem directly.
When accepting an offer of employment, what do you do about NCAs and NDAs that you might be asked to sign? Steve Jones offers some advice. (This editorial was originally published on Mar 12, 2008. It is being re-run as Steve is on holiday.)
Phil Factor argues that with both SQL Server and PowerShell now running on Linux, the latter becomes increasingly important in achieving the goal of a single management stack for databases across all hosting environments.
If all your application testing is done by test experts, who know how to record images, do screen-capture, write issue-reports to TFS more appropriate and consistent format and so on, you probably don't need the 'Exploratory Testing' chrome plug-in. Otherwise, it is worth checking out Ambily KK's walkthrough.
There are no more excuses for not having baseline data. This article introduces a comprehensive Free Baseline Collector Solution
This poll asks about copies, specifically those of your databases. How many do you keep around? How much extra storage does this cost? Steve Jones thinks that most organizations have quite a few copies, which can use a lot of resources.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Ruko Danau Sunter Utara, BLK. a 36D Jl. Danau Sunter Utara No.56, RT.11/RW.9, Sunter...
Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...
Gedung WTC Jl. Mangga Dua Raya. 8 Lantai 6, Blok CL 001, RT.CL, Jl....
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers