Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.

I'm trying to start/stop MS SQL Service on various DB servers (locally) but we don't always know the name of the instance (Always only 1 SQL Server running on a single server).

SQL makes it possible to work with very large datasets that would be hard to manage with the graphical interface. You can also save your SQL scripts to use in the future or share them with others ...

If you are running SQL Server in an Azure VM, or are using Azure SQL Managed Instance, you can use the Agent but may have needs that are beyond its scope. Here's an example from one of our clients.

I've run a SQL server on that little memory, but the user requirements were low (20+ users) and the database used was fully under my control and only a gig in size.<BR><BR>Just remember that SQL ...

PowerShell vs. SQL Server Management Studio When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 ...

Cross-site scripting (XSS) and SQL injection activity is up 32% in the third quarter, as those with malicious intent look to specifically target web-facing and cloud applications carrying sensitive ...