What is the Best Value for Fill Factor in SQL Server
Learn about how selecting a SQL Server index fill factor can impact storage and performance. Check out the included scripts to help give you better insight.
A Good Benefit?
A company is letting companies trade vacation for payments against student loan debt.
Using SQL Server and R Services for analyzing DBA Tasks
Article shows how R Services can help database administrators with their daily work
An Introduction to GitHub for DBAs
Distributed source control is really intimidating: branches, pull requests, merges – will somebody just take my code, for crying out loud? Why does it have to be so complicated and involved?
Treat All Sensitive Data as Important
No matter what the reason you have sensitive information, you need to treat it carefully.
The BI Journey: The Analyst
Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are just getting started. This article, by Data Platform MVP Gogula Aryalingam, describes how analytics can start small – with just one Power BI dashboard – and grow from there.
Azure Data Lake Analytics using U-SQL Queries
This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.
How Perfect Should Our Software Be?
Steve talks about the level of engineering effort we need in software development.
Learning about DML Triggers
Triggers can be confusing and complex for many developers new to SQL. Steve Jones gives a few ideas for learning more about this construct as well as practicing writing them.
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers