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.
2010-08-17
289 reads
Articles
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
2010-08-17 (first published: 2010-08-05)
4,657 reads
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.
2010-08-17
7,745 reads
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.
2010-08-17
2,348 reads
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.
2010-08-16
2,317 reads
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.
2010-08-13 (first published: 2008-08-13)
61,278 reads
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.
2010-08-13
2,438 reads
Finding Unique Non-Repeating Random Numbers
Learn three methods of creating random numbers that do not repeat in this article from Brandie Tarvin.
2010-08-12
9,560 reads
Creating Synchronization Providers With The Sync Framework
Microsoft Sync Framework is a comprehensive platform for synchronizing offline and online data, and facilitates collaboration and offline access for applications, services and devices alike. It is protocol- and database-independent and includes technologies and tools that enable device roaming, sharing and the ability to take networked data offline before synchronizing it back at a later point in time.
2010-08-12
1,693 reads
A Quick Look at the MPP World
David Poole takes a look at the Massively Parallel Processing world for database servers.
2010-08-11
4,580 reads
Blogs
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
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...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers