DMV Comparison for SQL Server 2019 vs Azure SQL Database
In this article, we look at Data Management Views (DMVs) differences between a SQL Server 2019 instance and Azure SQL Database.
Michelle is the SQL Server Team Lead at www.pythian.com, a worldwide company providing Remote Administration services for databases, operating systems, SANs and networks. Gutzait has been involved in IT for 20 years as a developer, business analyst and database consultant. For the past 10 years, she has worked exclusively with SQL Server. Her skills include SQL infrastructure and database design, performance tuning, security, high availability, disaster recovery, very large databases, replication, T-SQL coding, DTS/SSIS packages, administrative and infrastructure tools development, reporting services and more.
Dynamically Import data using a SQL Server Linked Server
If you have the need to import many tables using Linked Server whether it be from SQL Server to SQL Server or other database platforms this tip shows how you can dynamically load and automate the process.
Script to auto generate a security report for your SQL Server instance
A few of my clients have been asking me if I have a template for a security report they can send to their security auditors. I always prepare this report manually for them, using system procedures such as sp_helplogin, sp_helpuser, etc, and then format th
Auto generate SQL Server database attach and detach scripts
In this article we look at ways to gather info about databases to automatically generate attach and detach scripts for user databases.
SQL Server 2005 transaction log backup maintenance plan via SSIS
In SQL Server 2005, when you configure a transaction log backup maintenance task for all user databases, the transaction log backup task is not automatically checking the Recovery Model of the databases configured to be backed up. The result is that if
Do SQL Server User Defined Datatypes (UDT) affect performance?
Using User Defined Datatypes (UDTs) in the database has two major advantage; first, for columns that should have same data type and are, for example, compared or joined, by using same UDT, you can make sure that they are really compatible and secondly, yo
SQL Server stored procedures to page large tables or queries
I need to query a large amount of data to my application window and use paging to view it. The query itself takes a long time to process and I do not want to repeat it every time I have to fetch a page. Also, the number of rows in the result set could b