Provisioning
This week Steve Jones is asking about the timeframe for you to get a new SQL Server instance? Is it substantial? Do you really know? Answer this week.
2016-12-23 (first published: 2013-05-24)
127 reads
Editorial
Trusting Systems
The trust we build by ensuring our computer systems work is important. If we can't maintain that trust, Steve Jones sees a problem for our careers.
2013-05-23
97 reads
Understanding HA
Dealing with disaster situations or trying to maintain an HA environment can be stressful. However knowledge about your goals and the capabilities of each technology, along with practice, can make things much easier.
2013-05-22
228 reads
How do you solve T-SQL problems?
It's good to have a methodology for solving problems, and T-SQL is no exception to this. Steve Jones notes that all too often we look at solving a problem, but only doing half the job.
2013-05-21
415 reads
Powershell for DBAs
Powershell is a great tool for helping you work with multiple instances of SQL Server. This week Steve Jones talks about how and why you might want to get started.
2013-05-20
510 reads
Morphing Microsoft
Is Microsoft trying to move away from just being a software vendor? It seems they'd like to and that's a goal, but are they moving in the right direction? Steve Jones has a few ideas to help them.
2013-05-20
122 reads
The Control Poll
Do you use version control for your databases? For your application code? Is there a time when you think it's not needed? Steve Jones asks the question today.
2017-09-08 (first published: 2013-05-17)
158 reads
Honeywords in SQL Server
There's an idea of using false passwords with real accounts, honeywords, that can help us detect security issues with our servers. Is that worth implementing in SQL Server?
2013-05-16
197 reads
The Challenger
There is plenty of competition in the database platform space for SQL Server. There's a new NuSQL platform, whose vendor hopes will replace SQL Server as the platform of choice in the cloud. However Steve Jones isn't sure this will be the case.
2013-05-15
174 reads
The Platform Problem
Steve Jones sees a problem with the Azure platform. It's one that he thinks is limiting adoption, and may become a big problem for Microsoft at some point.
2013-05-14
206 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers