The Virtual Lab
Today Steve Jones talks about the need for a lab for each of us, and a few ways you can build one.
Window Functions in SQL Server: Part 3: Questions of Performance
A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do window functions run quicker than their conventional equivalent code? Fabiano Amorim gives a definitive answer.
A Leader
Today's editorial was originally reprinted on Jun 17, 2007. It is being re-run as it is a holiday in the US. Today Steve Jones looks at Jonthan Schwartz, the former CEO of SUN who took over from the founder, Scott McNealy.
DBAs and the Career-Life Balance
DBAs always tend to face many difficulties in maintaining a healthy work-life balance. Brad McGehee encourages some debate on the best strategies to make this work, in the face of long working hours, and the desire to contribute fully to the SQL Server community.
Grant Truncate Table Permissions in SQL Server without ALTER Table
How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.
Stairway to SQL Server Replication - Level 6: Merge Replication - Publication
This level covers the details of SQL Server transactional and merge replication, from understanding the basic terminology and methodology of setting up replication, to describing how it works and how the basic replication processes can be monitored.
Understanding and Using APPLY (Part 2)
The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.
WWBOD
This Friday's poll asks you to tell us what you'd do if you won the lottery. Is there something that you'd rather be doing than your current job? Dream a little and let us know.
SQL Server Log Shipping to a Different Domain or Workgroup
Sometimes the requirement arises to provide a copy of your database to an off-site location, such as a disaster recovery datacenter. Log Shipping is one of the most popular, proven technologies used to create a copy of your databases on a remote server.
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers