Migrating SQL Server Reporting Services
Learn how to migrate SSRS by following a walk through of migrating SSRS 2014 to SSRS 2016.
2020-06-12 (first published: 2019-03-18)
11,481 reads
Articles
The Database Development Stage
Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them.
2020-06-12
Why Organizations Need to Pay Attention to Cloud Security
As organisations move to cloud platforms like Azure and AWS, understanding security is more important than ever. In this article, Vasanth Makam explains what companies need to know to make sure their data is secure.
2020-06-12
Lock Scenarios Using sys.dm_tran_locks
Learn about the impact of locking and blocking in sessions through some demonstrations of different types of actions.
2020-06-11
2,032 reads
Getting Started with Automatic Database Branch Switching
Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database automatically remains 'synchronized' with the current branch in version control.
2020-06-11
Group By in SQL Sever with CUBE, ROLLUP and GROUPING SETS Examples
In this article we look at different examples of how to use GROUP BY with your SQL Server queries and the different results you get with the various options.
2020-06-11
Free eBook: SQL Server Transaction Log Management
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.
2020-06-10 (first published: 2013-08-14)
104,952 reads
Getting Started with Data Masker for SQL Server: I Want to Mask A Database
Grant Fritchey explains what's involved in masking a SQL Server database. It can seem a daunting task, but it all becomes a lot more logical if you start from a plan, based on agreed data classifications, and then use a tool like Data Masker to implement the masking, and track progress.
2020-06-10
Right-Sizing Row Mode Query Memory Requirements
When the optimizer doesn’t estimate the correct amount of memory for a query, either memory is wasted that could be used for other processes or some operations will spill to disk. Microsoft has added Memory Grant Feedback to help overcome this issue. In this article, Greg Larsen explains what you need to know about this new feature.
2020-06-10
Basic Git for DBAs: Sharing Files Through GitHub
This is the second article in a series on the basics of using Git. The other articles in the series are: Basic Git for DBAs: Getting Started with Git In the first article, we covered the basics. In this one, we will look at how to share our files with others. We will learn how […]
2020-06-09
3,347 reads
Blogs
Daily Coping 2 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Presenting on Ethics in Modern Data at Houston HASSUG/SQL BI Group July 2020 Meeting
By Will Assaf
Looking forward to presenting with my wife Christine Assaf our talk on Ethics in...
MVP for Another Year 2020-2021
By Tim Radney
Early this afternoon I received an email from Microsoft presenting me with the 2020-2021...
Forums
Expression expression runtime failure in SSIS
Hi Team, I have the following expression in ssis and the value of @[User::ExecutionId]=12dfg...
Daily Coping 2 Jul 2020
Today’s tip is share a happy memory with someone who means a lot to...
Query taking more than 4 hrs. - Any recommendations/suggestions?
One of our stored procs has been running for more than 4 hrs. and...
Ask SSC