[Video] Office Hours: SQL Server Career Q&A, Part 2
Last week, I posted a call for questions about SQL Server careers and professional development, and y’all asked a lot of good ones. Here’s the next video with the questions you upvoted the most, and I’ll post the last round of ’ …
Execute SSIS Package with SQLCMD and Parameters
The post Execute SSIS Package with SQLCMD and Parameters appeared first on SQLServerCentral.
Sharing SQL Code Snippets with Coworkers, The World and Yourself
The post Sharing SQL Code Snippets with Coworkers, The World and Yourself appeared first on SQLServerCentral.
How to Batch Updates A Few Thousand Rows at a Time
You’ve got a staging table with millions of rows, and you want to join that over to a production table and update the contents. However, when you try to do it all in one big statement, you end up with lock escalation, large transaction log usage, …
How To Install SSAS 2019
The post How To Install SSAS 2019 appeared first on SQLServerCentral.
Scheduling SQL Scripts Using Jenkins
Introduction There are scenarios where you need to schedule the SQL Server scripts without using SQL Server Agent, like when you use SQL Server Express edition. Mostly, the DBAs in this case is will choose to use the Windows task scheduler. However, Je …
The case for SQL Server Agent 2.0
Introduction SQL Server Agent enables the ease of scheduling routine tasks without leaving the comfort zone of SQL Server Management Studio (SSMS). This system stores all its related data in the msdb database. This article is going to discuss the need …
Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates
The post Tackling the challenges of hybrid, cloud, and on-premises SQL Server estates appeared first on SQLServerCentral.
How to Configure Amazon RDS SQL Server for Windows Authentication
The post How to Configure Amazon RDS SQL Server for Windows Authentication appeared first on SQLServerCentral.
Whitepaper: Enabling fast and easy database migrations with Flyway
The post Whitepaper: Enabling fast and easy database migrations with Flyway appeared first on SQLServerCentral.
The End of the Professional Association for SQL Server #SQLPASS
This afternoon, PASS announced that their operations will cease in January: We are saddened to tell you that, due to the impact of COVID-19, PASS is ceasing all regular operations, effective January 15, 2021. We encourage you to take full advantage of …
Frequently Asked Questions from Office Hours
In my Twitch & YouTube live streams, some questions seem to come up every week. I’m not expecting this post to stop ’em by any means – most folks on the live stream don’t seem to read the blog regularly – but I thought …
Join the Redgate Tool Tips Swap
The post Join the Redgate Tool Tips Swap appeared first on SQLServerCentral.
Using Azure Synapse Link for Azure Cosmos DB
Introduction In my previous article named An Introduction to Azure Synapse Analytics Workspace,I discussed the step-by-step process to create a Synapse workspace and how to use its components and features. Another article named An Introduction to …
SQL Server Error Log Configuration
Most applications have a log of some sort that tracks activity. SQL Server is no different. It has a log file known as the error log for tracking what’s happening on an instance of SQL Server. Server. Each instance of SQL Server has its own set o …