(Devi Prasad) Below is the TSQL Script to fetch the list of tables in a database with identity column properties
Tag: sql server
SQL SERVER – Fix – Error: Msg 468, Level 16, State 9, Line 1
(Pinal Dave) Ever since I have started writing about Error Messages a number of you ping me from time to time to understand why you are getting an error. As I always say, Error messages are a great way to learn concepts and we become better if we understand the reason behind every error one gets.
Dealing with an Inherited SQL Server
(Michael Otey) If you work with SQL Server you’ve most likely been there at one time or another. Maybe you’ve just started a new job, or you might be a Windows administrator who has been tasked to manage SQL Server, or you might be a consultant who has been brought in to deal with a specific problem
The concurrent snapshot for publication ‘X’ is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for
(Denny Cherry) Recently I was working on SQL Server Replication for a client, specifically removing and reading a table from replication to fix a different problem.
Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell
(Tim Smith) We have moved some of our SQL Server databases to Azure and we want to do periodic checks to make sure the databases are responsive. We want to setup a scheduled heartbeat check against the Azure databases. What options are there to automate this type of check?
Dealing with an Inherited SQL Server
(Michael Otey) If you work with SQL Server you’ve most likely been there at one time or another. Maybe you’ve just started a new job, or you might be a Windows administrator who has been tasked to manage SQL Server, or you might be a consultant who has been brought in to deal with a specific problem
The concurrent snapshot for publication ‘X’ is not available because it has not been fully generated or the Log Reader Agent is not running to activate it. If generation of the concurrent snapshot was interrupted, the Snapshot Agent for
(Denny Cherry) Recently I was working on SQL Server Replication for a client, specifically removing and reading a table from replication to fix a different problem.
Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell
(Tim Smith) We have moved some of our SQL Server databases to Azure and we want to do periodic checks to make sure the databases are responsive. We want to setup a scheduled heartbeat check against the Azure databases. What options are there to automate this type of check?
TSQL Script to Clear SQL Server Cache
(Devi Prasad) Below script that can be used to clear SQL Server Cache. Helpful while working on performance tuning of SQL Scripts.
Securing your Azure Virtual Network using Network ACLs with Narayan Annamalai
(Scott Hanselman) Senior Program Manager Narayan Annamalai teaches Scott how to use Network ACLs (Access Control Lists) within an Azure Virtual Network. You can create control access to objects within Azure by subnet and network!