Our company’s entire IT infrastructure is growing rapidly, but our SQL Server environment is growing exponentially faster. My team needs to make sure we have consistency across our SQL Server instances.
There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another opti
We've found that writing a resume continues to be the biggest pain point for job seekers, followed closely by interviewing and effectively applying for positions so your resume gets seen and you get an interview request! In this cookbook, we're excited to
Learn about options to copy a table from one SQL Server database to another including Linked Servers, PowerShell, Integration Services, backup and restore along with the associated performance metrics and completion time.
Azure Resource Manager (ARM) is the deployment and management service for Azure. It provides a consistent management layer that enables you to create, update, and delete resources in your Azure subscription to help you keep things consistent.
In this series of tips we will look at different ways using temporary data in SQL Server along with examples. In this first part we will cover some reasons for doing this and different types of temporary data stores.
Check out this PowerShell script that will help identify size of the MSDB database as well as the largest table in the database across all of your instances to make decisions on the needed SQL Server maintenance.
I need way to roll-up multiple rows into one row and one column in SQL Server. I know I can roll-up multiple rows into one row using Pivot, but I need all of the data concatenated into a single column in a single row.