The Apprentice
This Friday Steve Jones asks if we should reconsider the way we train developers and other computer professionals. Give us your opinion this week.
The SQL Server Query Optimizer
To understand how to write SQL code for SQL Server that performs well, it is important to appreciate how the query optimizer works. Ben Nevarez explains the essentials, in a broad sweep through a complex subject, in an article taken from his new book 'Inside the SQL Server Query Optimizer'.
Find which port SQL Server is using to establish connections
This article will show you how to determine which network port that SQL Server is listening on for connections
Learning for Profit
Today Steve Jones talks about a way to improve your skills, make yourself more marketable for that next job, and perhaps earn some money.
Initialize SQL Server replication using a database backup
You need to configure transactional replication for a very large SQL Server database. Instead of running the snapshot agent to initialize the subscriber, in this tip we look at how you can initialize the subscriber from a SQL Server backup.
The Robot DBA
Steve Jones talks about the idea of an automated DBA and disputes the notion that it will come to pass anytime soon.
SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Execute DDL Task
The term DDL designates Data Definition Language, which implies an action involving creating data structures. In the context of Analysis Services Execute DDL Task, this is a bit of a misnomer because its capabilities are much more diverse, extending to such areas as backups, restores, deletions, modifications, or processing. This is accomplished by employing Analysis Services Scripting Language (ASSL).
10 Bad Things About Reporting Services 2008 R2
SSRS 2008 R2 introduced lots of exciting new features, reviewed in a sister article to this one. Here we consider what Microsoft didn't do well in this version of Reporting Services.
From Vandalism to Serious Crime
It seems that there are new types of hacker attacks, not looking to steal information for profit, but for disclosure as an embarrassment. Steve Jones talks about the potential downsides for DBAs.
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers