SQL Lunch Recordings Now Available
After several tries I think we finally have it working. If you were unable to attend the last two SQLLunches,...
SQL Server Security Audit Report
If your company needs to go through a SOX (Sarbanes–Oxley) audit or any security audit, the DBA has to provide security information to them. If you have purchased third party tools to provide this information that is great. If you don't have third party tools and need to go through many servers to provide this information it can be a hassle and very time consuming. So I put together a script to generate a report that I could just review. The script generates a report of all elevated level accounts and any possible security holes.
Easy Licenses
Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.
Let's Talk Ownership (and SQL Jobs)
It seems that the ownership of jobs is something that is often overlooked when articles explain
The WorkTamer Conference
The Worktamer conference is coming to a series of cities in Canada in early 2010. If you're near Vancouver, Toronto, or Montreal, read about this one day event to help you boost your professional development.
Easy Licenses
Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.
Easy Licenses
Software licensing can be complex and confusing. Even in Windows and SQL Server, where hard limits are not enforced, people have problems determining how they should license software. Steve Jones talks about what vendors could do to help us.
Full Text Index Implementation in SQL Server 2005 Express Edition
Continuing our discussion, this article covers the remaining tasks necessary to implement a full-text index in SQL Server 2005 Express Edition.
Installing SQL Server 2005 Reporting Services 32-bit on a 64-bit Windows Server system
You have a Windows 64-bit server and need to install the 32-bit version of SQL Server 2005 Reporting Services on this machine. In this tip I will walk through the steps you need to take for this installation.
Interview with the Scary DBA – Grant Fritchey
With Halloween so near, we thought it would be a good time to find out more about the so-called Scary DBA, Grant Fritchey, who's been working in IT for 20 years now. He writes for SQL Server Central, Simple-Talk and SQL Server Standard, and was awarded MVP status earlier this year. We sent Richard Morris to meet him.
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers