Creating Azure SQL Data Warehouse Databases
Learn how you can create an Azure SQL Warehouse database quickly and easily.
The Cost of Database Downtime
Do you know what the cost is for your database going down? Maybe more interesting, is do you want to know?
Integrating DACPAC deployments of Azure SQL Database with Visual Studio Team Services
One of the concepts that has recently been growing rapidly in popularity, in the context of cloud technologies, is DevOps. In this article, Marcin Policht looks at using DevOps principles in regard to Azure SQL Database deployments. To implement some of the more common DevOps practices, he will rely on Visual Studio Team Services.
AI Helpers or Replacements
The future will see more of our data used in machine learning and other AI-like systems. Is that something we want?
Nuance of datetime data type in SQL Server
One of the most confusing data types in SQL Server is the datetime datatype.
Harmful, Pervasive SQL Server Performance Myths
Aaron Bertrand begins a new series around disproving prevalent myths regarding SQL Server performance.
The Value of Your Personal Data
Today Steve Jones discusses the idea of data value, and what it might mean to you, personally.
Automating database deployments to and from source control using SQL Compare and PowerShell
Phil Factor shows how you can use the SQL Compare Pro command line with PowerShell to automate the task of getting a new database into version control, creating a new database build script, and creating a database migration script.
Dynamic SSRS report documentation via a ReportServer.dbo.Catalog query
This article demonstrates a method of generating SSRS report documentation by using an SSRS report that queries the ReportServer.dbo.Catalog table.
Blogs
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers