Configuring Kerberos Authentication
Longtime author Brian Kelley brings us a new article on security and Kerberos authentication in SQL Server.
How to Deal with the Stresses and Anxieties in Today's IT Industry
Today we have a guest editorial from Stanley Popovich that talks about dealing with stress at work.
Patch Week
With SQL Server releasing new cumulative updates this week, Steve Jones talks about the patching strategy of SQL Server.
SSRS Reports Performance Debugging and Analysis
SSRS provides a very user friendly way to author and deploy reports. These reports can be accessed from different platforms where the reports are deployed - reports manager, SharePoint, stand-alone / distributed applications or programmatically using SSRS SOAP endpoints. Unfortunately, SSRS / BIDS does not provide any high-end debugging tools such as SQL Profiler for analyzing the performance of SSRS reports. In this tip we will look at different ways of debugging and analyzing SSRS reports performance using execution logs and freeware tools.
Statistics, row estimations and the ascending date column
SQL’s auto-updating statistics go a fair way to making SQL Server a self-tuning database engine and in many cases they...
The default trace in SQL Server - the power of performance and security auditing
Since the introduction of SQL Server 2005, there is a simple lightweight trace that is left running by default on every SQL Server. This provides some very valuable information for the DBA about the running server, but it isn't well-documented. Feodor Georgiev reveals many of the secrets of this facility and shows how to get reports from it.
What Differentiates Enterprise?
This Friday Steve Jones asks you about the Enterprise Edition of SQL Server, and what should the distinction be?
SQL Server 2008 Service Broker - Conversation Priorities
SQL Server 2008 Service Broker lets you process higher priority messages and conversations earlier than those with lower priority.
SQL Server Startup
From time to time I see a question asking how to determine the last time a SQL Server was either...
Do You Need A Safe Word?
A hacker breaches security by gaining control of an executive's email account. Does that mean that we should consider adding another level of authentication to privileged requests?
Blogs
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
SQL Server Migration Overview
By Kevin3NF
It’s Not Just Backup / Restore At some point every company faces it: the...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Can/Can't Do/Don't
Comments posted to this topic are about the item Can/Can't Do/Don't
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers