Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
The Voice of the DBA
 

A Well Deserved Break

This is my last day of work. Not forever, just for six weeks. I'm off on my sabbatical after today and won't be back until August 11. However, everything should run smoothly with Grant and Kellyn holding things down until I return. Have a little patience with them as this site can be a bit of a hectic whirlwind at times, and they still have other jobs to do.

It's been a wild first half of the year. After very little travel in Jan/Feb, the rest of the year has been a bunch of travel, including most of May and June being on the road. With coaching responsibilities for two teams from Jan-Apr, I am ready for a break. No big plans, but I am looking forward to being at home, playing some guitar, working on a few projects while trying to be very unwired for six weeks.

I know most of us tech professionals likely deserve a break from work at some point. I am very lucky to get a sabbatical, on top of vacation allowances. It took my a number of years to understand and learn to relax while on breaks. Too many years of being on call, owning a business, and driving my career forward had me delaying or skipping vacations some years. I carried over a lot of days from year to year at many positions.

That's a bad idea.

We need breaks. We need to recharge, and while I wasn't thrilled when Redgate's policy changed, I have come to appreciate it. We can only carry over a week, and I try not to do that in any year. They want employees to take breaks, and I try to do so. My wife certainly appreciates me getting away from work and not checking email, Slack, etc. I was nervous the first few times I left SQL Server Central for a week, often trying to get an hour of work to check on things every morning while on vacation. I come to trust that everyone at Redgate will keep an eye on things and ensure the site keeps running.

I may still blog about the sabbatical, but I don't know it will be any sort of priority. I've been quite busy up until today and haven't had time to plan much of anything. That won't make for any interesting blogs, but it will be a well-deserved break.

 

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

 
  Featured Contents
SQLServerCentral Article

Why Clone Fails: Discovering the Hardware Beneath Azure SQL MI

Tonie Huizer from SQLServerCentral

In this next part of the series on Managed Instance, we see how to discover a bit about the internals of how the instance is being run. Learn how to kill and respawn a Managed Instance.

External Article

Retrieving SQL Server Index Properties with INDEXPROPERTY

Additional Articles from MSSQLTips.com

SQL Server has several functions to assist with meta data about the server, databases, indexes, and more. In this tip, we will look at how to get index information for indexes in a database using the INDEXPROPERTY function.

Blog Post

From the SQL Server Central Blogs - Advice I Like: Focus on what’s important

Steve Jones - SSC Editor from The Voice of the DBA

Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by the urgent of any sort. Focus on the important. The urgent is a tyrant. –...

Blog Post

From the SQL Server Central Blogs - Starting Points for Quantum Computing Learning

K. Brian Kelley from Databases – Infrastructure – Security

I didn't have these in my slides for the Techno Security & Digital Forensics Conference, but brought them up the web browser during the presentation. If you're looking at...

Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence

Site Owners from SQLServerCentral

A step-by-step guide to harness the power of Microsoft Fabric in developing data analytics solutions for various use cases

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Multiple Defaults

In my SQL Server 2022 database, I run this code:
ALTER TABLE dbo.OrderHeader ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GO 
I decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE() GO 
What happens with these statements?

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Getting the Updated Column List

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge SET CustomerContactFirstName = 'Andy' WHERE CustomerID = 1 SELECT COLUMNS_UPDATED() 

Answer: NULL is returned

Explanation: The COLUMNS_UPDATED() function only returns data inside of a trigger. Otherwise, this returns null. Ref: COLUMNS_UPDATED() - https://learn.microsoft.com/en-us/sql/t-sql/functions/columns-updated-transact-sql?view=sql-server-ver16

Discuss this question and answer on the forums

 

 

 

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.


SQL Server 2016 - Development and T-SQL
Merge techniques - In Azure SQL DB, i want to merge records from the staging table to the production table. In the production table, there are 300 million records. In staging, Delta records are 40 million. there are 100+ columns in each table.... If the column value changes from staging to production, update the record. If it is […]
Getting year part out of a string that represents a date - Hi, I have a requirement to fetch the year from an imported .csv  file that can hold any kind of date , in any format as delivered to use by municipalities that manage to get their own ideas of the template they need to use. Basically the date can have many formats , like  YYYY-MM-DD […]
Dropping a PK constraint. - I will have to test this next week, but will not have a chance before Friday. My question is, if I backup table data, drop a PK to add it back as an identity PK, will the foreign keys referencing the PK still be in tact? The new PK (now with identity) will keep the […]
SQL Server 2019 - Development
Is there a way to implement ROWS between logic? - Hi everyone SUM function has the option to select ROWS BETWEEN parameter to allow for a rolling sum calculation.  This is very useful.  I would like to do the same for PERCENT_RANK but this function does not have this option available.  Suppose there are 100 daily records and I want to calculate the PERCENT_RANK on […]
Reporting Services
SSRS error: The Value for the image 'Image1' has a constant value... - Full error message: SSRS error: The Value for the image 'Image1' has a constant value. Value requires a binary value, so it cannot be a constant. The image is in the "Page Header", and comes from a database column that was originally the image data type, but doing a convert on the query to the […]
Editorials
The Data Warehousing Choice - Comments posted to this topic are about the item The Data Warehousing Choice
Shades and Reflecting on SQLBits and the Bright Future of Data - Comments posted to this topic are about the item Shades and Reflecting on SQLBits and the Bright Future of Data
Multiple Monitoring Tools - Comments posted to this topic are about the item Multiple Monitoring Tools
Article Discussions by Author
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned - Comments posted to this topic are about the item The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned - Comments posted to this topic are about the item The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned
How to Choose the Right Tool for MS SQL to PostgreSQL Migration - Comments posted to this topic are about the item How to Choose the Right Tool for MS SQL to PostgreSQL Migration
SQL Server 2022 - Administration
SQL Server 2008 to SQL Server 2022 - Hi, Is it possible to upgrade from sql server 2008 to sql server 2022, considering we have hardware req fulfilled? Or like we have to upgrade to sql server 2014/16 midway and then from there to sql server 2022 A normal backup and restore will suffice? Any ideas ?  
SQL Server 2022 - Development
Best Compliance Training for Professionals to Stay Ahead of Regulations - Finding the best compliance training is essential for professionals who need to stay current with ever-evolving regulations. Whether you're in HR, payroll, finance, or management, proper training helps protect your organization from costly mistakes and legal risks. Supreme Trainer offers expert-led, online compliance webinars that are practical, up-to-date, and easy to access. From mastering Form […]
XML_COMPRESSION for existing tables - We are in the process of upgrading to SQL Server 2022 and would like to make use of the XML compression feature it offers, as we have a handful of tables that store considerable amounts of XML data. I suspect the answer is "no", but is there a way to enable XML compression on an […]
SQL - Conditional merge join - I want to add a condition in the joining columns part of the merge statement like this : Merge dbo.tblDest as target using (select ...) as source on target.EmpID =  source.EmpID and target.AwardID = source.AwardID  --this second condition I want to add only if the source.AwardID is not null. How to do that pls advise. […]
 

 

RSS FeedTwitter

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here. If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. This newsletter was sent to you because you signed up at SQLServerCentral.com.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
webmaster@sqlservercentral.com

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -