Convert Mirroring to Log Shipping
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
Additional Columns in StreamInsight Event Flow Debugger
This tool is excellent when investigating what is going on in your StreamInsight Streams. I was looking through the menu items recently and went to Query => Event Fields I found that there were a couple of columns not added by default to the event viewer (Reminds me of the fact that the Variables viewer in SSIS hides columns also) Latency NewEndTime EnqueueTime Here they all are together. This gives us even more information about what is going on
Can you set a pagefile more than 4GB?
Can you set a pagefile on a Windows machine to more than 4GB? Stanley Chan shows us how after an issue with a crashed Windows machine.
Penalties
Terry Childs gets sentenced for refusing to turn over passwords to his boss. Steve Jones reminds us that we work for someone and that we have to remember that when taking a stand.
Run SQL Command Against Multiple Instances Without CMS
I understand that I can use Central Management Servers to run a T/SQL query against multiple instances at once - can I do this without CMS though?
Beginning SQL Server
A presentation by Steve Jones that talks about the technical basics of what SQL Server is and how it works with some hints about backups, security, and more.
Improving database development with SQL Source Control
A webinar sponsored by Red Gate Software showing you how easy it can be to source control your database code. Thursday, August 19, 2010 12:00 PM EDT
Keeping Engaged
How can you better keep employees engaged in your company? Keep them happy and hopefully retain them for a long time? Steve Jones has some comments today.
SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution
DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.
Performing a Left Anti Semi Join in StreamInsight
Performing a LEFT OUTER JOIN in TSQL is easy. The same logic in StreamInsight requires a little more work. In this presentation I show exactly how you can perform a LEFT OUTER JOIN on your event streams. Your browser cannot play this video. Learn how to fix this.
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers