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.
A Server is Not a Machine
With cloud computing use growing, and SQL Server Azure becoming more popular, Steve Jones wishes this would become a product that the rest of us could deploy.
Turn a Bad Job into a Good Experience
Today we have a guest editorial from Tim Mitchell that tells you how to turn a bad job into something more.
Identify Databases Not in SQL Server 2008 Compatibility Level Using Policy Based Management
You need to periodically ascertain if there are any databases in your production environment which are not in SQL Server 2008 Compatibility Level. In this tip we cover the step by step process for setting up a policy to identify databases that are not in SQL Server 2008 Compatibility Level.
Excel with Stored Procedures
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
The Value of Blogging
Today we have a guest editorial from Andy Warren that talks about the value of blogging.
Configuring Kerberos Authentication for Microsoft SharePoint 2010 Products
This document provides you with information that will help you understand the concepts of identity in SharePoint 2010 products, how Kerberos authentication plays a critical role in authentication and delegation scenarios, and the situations where Kerberos authentication should be leveraged or may be required in solution designs. The document also shows you how to configure Kerberos authentication end-to-end within your environment, including scenarios which use various service applications in SharePoint Server. Additional tools and resources are described to help you test and validate Kerberos configuration. The "Step-by-Step Configuration" sections of this document cover several SharePoint Server 2010 scenarios.
Failed IT Projects
A new theory of why some IT projects fail has Steve Jones intrigued, however he thinks we can do better, and not just with better developers.
Finding Unique Non-Repeating Random Numbers
Learn three methods of creating random numbers that do not repeat in this article from Brandie Tarvin.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Cemara Asri CSTelpon : 0853-73737551
Komplek Cemara Asri, Jl. Boulevard Timur No.08B, Medan Estate, Kec. Percut Sei Tuan, Kabupaten...
BCA KCU MUARA KARANG Telpon/wa.085373737699
BCA KCU MUARA KARANG Telpon/wa.085373737699.Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus...
Alamat Kantor BCA KCU SEMARANG Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers