Email Issues with SQLServerCentral
We are experiencing some email issues with our sender. There are some spam reports for our newsletter, which are causing us issues. If you have any questions, please contact the webmaster@sqlservercentral.com.
Ten tips for building a collaborative DevOps culture
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
Upgrade and Migrate SSRS Report Server and Retain Server Name
In this article we look at how to do a side by side install of SQL Server Reporting Services to minimize downtime for the migration.
Working in a Distributed Fashion
With many of us working in a distributed fashion, Steve wonders if things have changed for the process flow you follow.
Five facts about the SQL Server Tempdb Database
In this article we cover some interesting facts about the SQL Server TempDB database that could be useful to know.
SQL Templates and Code Snippets in SSMS and SQL Prompt
Phil Factor explains the uses and limitations of native SSMS templates and snippets, and then demonstrates the extra versatility that SQL Prompt snippets provide.
Why Doesn't Database Software Help Us?
Databases don't manage themselves, but Steve sees this as an opportunity, not a problem.
How to deploy and execute an SSIS package from the SSISDB catalog
Beginning with SQL Server 2012, SQL Server Integration Services packages can be deployed and executed from a SQL Server database named SSISDB, which serves as a repository for SSIS packages.
Tool Limits
Today Steve asks about the tools you use for your job and if they help or hurt your productivity.
Azure AD Authentication for Azure SQL Databases
In this article we walk through how to connect to Azure SQL Database using Azure Active Directory authentication along with multi-factor authentication.
Blogs
A New Word: Ochisia
By Steve Jones
ochisia – n. the fear that the role you once occupied in someone’s life...
Create a Numbers Table in Power Query
This is a quick blog post, mainly so I have the code available if...
Microsoft finally adds Tenant Switcher for Fabric / Power BI
Praise whatever deity you believe in, because it’s finally here, a tenant switcher for...
Forums
Need help with GROUP BY...
Here's my data... I am trying to return total days in status for each...
Need help with GROUP BY...
Here's my data... I am trying to return total days in status for each...
Question of the Day
The Density Vector
When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?
See possible answers