Getting Started with Azure Blueprints
Learn about Azure Blueprints, available in the Azure portal, which is a new method of deploying Azure Resources through ARM templates.
2020-07-30
Articles
Creating a Simple Development Harness with SQL Compare and SQL Data Generator
There is no single, correct approach to developing and testing your SQL batches and routines. It depends on the requirement. For simple tasks, like modifying and testing a view or stored procedure, SQL Compare and SQL Data Generator, combined, provide a useful, lightweight development harness.
2020-07-29
Free eBook: Fundamentals of SQL Server 2012 Replication
Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.
2020-07-29 (first published: 2014-02-26)
82,179 reads
What If You Really DO Need to Shrink a Database?
You’ve heard that shrinking a database is bad because it introduces both external and internal fragmentation, it causes blocking, it causes transaction log growth while it runs, and it’s slow and single-threaded. You understand that if it’s just a matter of 10-20-30% of a database, and the database is only 100-200GB, you might as well just leave the space there, because you’re gonna end up using it anyway.
2020-07-29
Access external data from Azure Synapse Analytics using Polybase
Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.
2020-07-28
814 reads
Exploring the SQL Compare Options
Phil Factor dissects and disentangles the various SQL Compare options.
2020-07-28
How to Expand a Range of Dates into Rows using a SQL Server Numbers Table
In this article we look at different T-SQL code examples that can help you build a range of date rows based on a starting and ending date.
2020-07-28
SQL Server 2012 does not come up after service pack upgrade SP4
A failed SQL Server Service Pack upgrade is fixed with a trace flag.
2020-07-27
2,911 reads
SQL Server TempDB Tutorial
In this article we cover many different questions about the SQL Server TempDB database to give a better understanding of what is and what it is used for.
2020-07-27
2020-07-24 (first published: 2018-12-27)
3,826 reads
Blogs
What you need to know About Azure SQL backup
Most of DBA are coming from On-premise Database Servers they know very well How...
Social: Respecting Names
By Steve Jones
This is a non-technical post, and my opinion. If you don’t want to read...
Proud to present at this year’s VMworld 2020 conference
By kleegeek
I’m thrilled to support and participate in this year’s VMworld 2020 conference, which is...
Forums
SSIS DB migration from one server to other server.
Summary: We had migrated SSISDB from SQL Server version 11.0.6260 to SQL Server version...
Permission to view SQL jobs in SQL Server 2017
Hi, I'm using SQL Server 2017, I need to give developers only to view...
Ask SSC