Service Pack 4
This week Steve Jones asks if Service Pack 4 for SQL Server 2005 is coming out and makes an argument why it should.
Auditing in SQL Server 2008
Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
TSQL Challenge 20 - finding repeating digits on Fibonacci sequence numbers
Can you generate repeating digits in a Fibonacci series?
Importing SharePoint ULS and IIS Logs into SQL
Importing data into SQL Server is one of the strengths of the platform. However it can require a bit of work for a DBA to make this an automated process. New author David Jansen brings us a technique for importing Sharepoint and IIS logs into SQL Server for later analysis.
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
Introduction to SQL Azure
Learn how to get started working with SQL Azure and migrating SQL Server databases to SQL Azure.
MySpace Using SSDs
Glenn Barry (blog, twitter) posted a note about MySpace using Fusion-IO PCi-E cards to replace hard drives in their systems....
Twas the Night Before Christmas - SQL Style
A guest editorial from Tim Ford updates this Christmas classic for the SQL Server professionals out there.
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers