10 New Features Worth Exploring in SQL Server 2016
Greg Larson gives an in-depth look at ten of the new features you can expect from SQL Server 2016.
Leave Developers Alone
Interruptions are the enemy of productivity for creative people, like software developers. Steve Jones talks today about the need for quiet time.
Top 10 Most Common Database Scripts
What are the scripts that a working DBA uses so often that they become part of the 'muscle memory'? Grant Fritchey asked the question on the forums of SQL Server Central. From the large response, Grant was able to pick out the ten most popular T-SQL commands, scripts, or fragments. It seems as if, despite the range of tasks we do, there are some common tools we use.
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
SQL Prompt Tips #3 - Snippet Placeholder $Paste$
Another quick tip for SQL Prompt, using the snippets to increase your productivity.
Using Power BI in a Hybrid Environment
This paper describes best practices for security, networking, and component architecture for building a hybrid business intelligence (BI) environment by using a combination of Microsoft Office 365, Microsoft Azure, and on-premises data sources. Many organizations are taking advantage of the benefits of cloud computing such as lower capital expenditures and increased agility, while still maintaining data in on-premises data stores.
From Great Idea to End Result
IT is too slow. That was a quote that inspired this piece from Steve Jones that talks about the need for IT to be more flexible and agile in their efforts. That includes the data professional in their modeling.
Simple Mathematical Formulas using the M Language
The Power BI desktop designer is a great tool; however, the hardest part of any Business Intelligence project is gathering and formatting the data into reportable datasets. John Miner explains how having a deeper understanding of the M language will help a BI developer in cases where the menus can not.
The Hot Jobs
This week Steve looks at the hot jobs that are going to have pay increases in the coming year.
The Complete Guide to PowerShell Punctuation
It is the punctuation, the strange dollar signs, brackets and parentheses that bewilder anyone learning PowerShell. Add to that the aliases and you can bewilder everyone. The punctuation is essential, so here is the the complete PowerShell wallchart and guide to Powershell Punctuation. Thanks to Michael Sorens, PowerShell need no longer be perplexing.
Blogs
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers