SQL Server management, tutorials, scripts, coding, programming and tips for database administrators
Microsoft provides a number of different deployment options for its Azure SQL Database offerings. While most of them share the same characteristics, one in particular warrants special attention from the standpoint of its infrastructure dependencies. That exception is Azure SQL Database Managed Instance, which will be the topic of this article.
In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. Read on to explores the concept behind and learn how to declare cursors, open, retrieve data from them, and then close them.
Discover how to do both in one SQL Server statement: Verify that a SQL Server object exists and drop the object.
Auto-Failover Groups addresses several limitations that were in the Azure SQL Database. Read on to learn more!
With the introduction of SQL Server 2019, Microsoft introduced a new method to count distinct values that can be faster and uses less resources. Read on to learn more!
Discover the primary characteristics of Database Console Commands (DBCCs) on Azure SQL Database and explore their role in Database-as-a-Service scenarios.
Running Transparent Data Encryption (TDE) in the SQL Server database engine asynchronously might take a while to encrypt the entire database. Read on to learn how to suspend and resume TDE to keep your system performant.
See step-by-step how to create a data-centric mobile app using common tools including SQLite and C#. To learn about these tools and how to create a simple mobile app, read on!
Azure SQL Database allows for stateful services in the cloud. Read on to learn about the characteristics and use cases of the Azure SQL Database serverless tier.
If you are wanting to manipulate numeric data with mathematically, then you will wan tot read on to get an overview of the core SQL numeric functions
Sniffing could be beneficial to your SQL Queries. Learn about parameter sniffing as well a how to turn it on by default.
Learn about the range of connectivity options available for Azure SQL Database deployments.
Get an introduction to many of the many ways you can manipulate and interact with strings using SQL. Read on for more!
As a DBA it is important to have a toolbox that supports the work you do. You need to have a toolbox that allows you to work smarter instead of harder. Read on to learn about some key tools every DBA should have in their toolbox!
Read on to step through the process of implementing Azure Data Factories.
MS SQL Archives