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
515 reads
Editorials
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
202 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
184 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
216 reads
Data Science Sanity Checks
Phil Factor on three "sanity checks" that any data scientist must perform in order to prevent businesses from interpreting data analysis errors, or fraudulent activity, as real trends.
2013-05-13
159 reads
Visualizations
A picture can express a thousand words. That's a phrase that many of us understand well, and one we embrace when we try to present large amounts of data in reports and dashboards. This week Steve Jones asks you what visualizations you use.
2013-05-10
165 reads
A Broken Data Model
After a recent trip, Steve Jones noted a problem somewhere with the way airlines are handling passenger data.
2013-05-09
162 reads
Our Race with Machines
A future world where the machines rule, as shown in films like Terminator and the Matrix, isn't what most people want. However the fears of machines taking over much of our world are very real. Steve Jones thinks it's not as bad as you might believe.
2013-05-08
121 reads
Small Data
With all the talk about Big Data recently, Steve Jones looks at some of the issues with Big Data and how small data might be more important to you.
2013-05-07
183 reads
Microsoft Research
Research in industry can help a company leap ahead of it's peers. Steve Jones thinks this is a good idea for many companies to engage in and highlights some of the great work being done at Microsoft Research.
2013-05-06
97 reads
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers