Big data can be risky, which is why you need great estate management. Join Matt Schmelzer, Data Systems and Automation - IT, and Jonathan Holck, IT Associate, from Artisan Partners in discussion with Microsoft MVP Grant Fritchey to learn how they implemented a successful infrastructure and what tools they need to support their growing estate.
2021-10-13
Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.
2021-10-13
There are many ways to load data into a SQL Server database. In this article, Greg Moore demonstrates how to get PowerShell to do more of the work.
2021-10-11
We’re sharing the results of our State of Database Monitoring survey in four insights reports this year – and the second one is out now. In The value of a monitoring tool for the entire organization you’ll learn why more businesses than ever are using a monitoring tool and how doing so can help the entire business to reduce costs, enhance security and collaborate more efficiently. DBAs - download a copy and send it to your boss, today!
2021-10-11
In this article we cover how to implement a batch Databricks Change Data Feed process through an end-to-end exercise.
2021-10-08
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
2021-10-08
Learn about the various ways to use the GROUP BY command to summarize and rollup query results. We look at the basics with examples as well as using group by rollup, cube and grouping sets.
2021-10-06
Join Kevin Davis, DBA Manager at Tower Loan to hear their playbook for successful distributed estate monitoring, and the role of SQL Monitor.
2021-10-06
Extended Events have been part of SQL Server since 2008. In this article, Ed Pollack explains the building blocks of Extended Events data collection.
2021-10-04
Microsoft Data Platform MVP Glenn Berry demonstrates a set of eleven SQL Server Diagnostic Memory Queries that help you understand your memory usage in SQL Server.
2021-10-04
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Comments posted to this topic are about the item Unraveling the Mysteries of the...
Comments posted to this topic are about the item QUOTENAME Behavior
Good Morning. I have a T-SQL Script which has been developed to execute a...
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers