MDX, DMX, and XMLA Templates
One of the most underused features in SSMS is the additional templates that are available for MDX, DMX, and XMLA....
2009-11-20
1,217 reads
Articles
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,...
2009-11-20
1,911 reads
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.
2009-11-20
3,602 reads
Let's Talk Ownership (and SQL Jobs)
It seems that the ownership of jobs is something that is often overlooked when articles explain
2009-11-19
9,027 reads
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.
2009-11-19
291 reads
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.
2009-11-19
1,026 reads
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.
2009-11-19
2,933 reads
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.
2009-11-19
2,159 reads
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.
2009-11-19
2,951 reads
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.
2009-11-19
576 reads
Blogs
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...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers