Managing Log Files Sizes the Easy Way
Learn an easy, rough, and ready way to manage log files in this piece.
Introduction to C# Scripting for SQL Server DBAs
Microsoft has introduced an interactive C# scripting technology inside the Visual Studio 2015 environment. In this post, Jeffrey Yao looks at how we can use this to perform SQL Server tasks.
Solving an SSIS Error – Cannot convert between Unicode and non-Unicode
When loading data with SSIS, sometimes there are various errors that may crop up. This article provides a solution when you get have a problem between Unicode and non-Unicode fields.
This is how to fail
Today we have a guest editorial from Tim Mitchell that talks about security and communications with your customers. Ultimately it pays to be open and honest.
Deploying schema changes to multiple databases using the SQL Compare command line
Feodor Georgiev explains how SQL Compare Pro makes it possible to automate the process of synchronizing a source and target database. By calling SQL Compare from a simple batch script, he shows how to make it work for a whole list of targets, one after another.
Listing Duplicate Values by Group
Without question, one of the most common tasks performed by Database Administrators (DBAs) is identifying and weeding out duplicate values in tables. Despite the inordinate number of queries written by other DBAs to locate duplicate values in their database tables, the real challenge is in locating a useable SQL statement to go by. Rob Gravelle presents a few solutions that will save you some time down the road.
The Hibernate ORM and SQL Server
Using an ORM with SQL Server introduces unique challenges. I have listed a few of my experiences, hoping it can help someone.
Retrieving SQL Server Query Execution Plans
Execution plans explain all you need to know about query performance, and how to fine-tune. Sure, you can see them in SSMS, but what if you need to drill into to the important details? What about using DMVs, Extended Events or SET statements to get at the execution plans? To get the best use of execution plans you need to be able to get right information from the right plan at the right time. Robert Sheldon explains how.
DBAs Need to Learn to Develop
SQL Server is growing as a platform and Steve Jones says that DBAs need to learn development skills.
Blogs
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Impactful Sessions I’ve Seen: T-SQL Tuesday #196
By Steve Jones
This month I’m thrilled that Steve Hughes is hosting. I’ve read this Data on...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers