How Do the Experts Become Experts?
How do the experts get to that level? A few thoughts today in a guest editorial from Kathi Kellenberger.
2026-06-10
226 reads
How do the experts get to that level? A few thoughts today in a guest editorial from Kathi Kellenberger.
2026-06-10
226 reads
Books used to be the source of knowledge, but times have changed.
2026-05-25
223 reads
If you have been working with SQL Server long enough, you have probably been involved with a SQL Server 2000 to 2005 upgrade. It was painful for many shops due to the deprecation of some features like DTS and the removal of old-fashioned comma joins with the plus operator. It was worth the pain as […]
2019-03-25
1,320 reads
From the time you rise in the morning until you close your eyes at night, your day is filled with thousands of small decisions, many that you don’t even think about. For each decision that you make, there is a probably a good choice and a poor choice available. Most of the time, the good […]
2019-01-28
190 reads
This year, PASS celebrated the 20th PASS Summit. As it has been many times, this year’s Summit was held in Seattle. PASS Summit has visited other locations such as Orlando and Charlotte, but, at least to me, it feels like home when it’s hosted in Seattle. For those of us who have participated for many […]
2018-11-19
71 reads
Have you ever had a difficult time explaining what your job entails to your parents or other family members? You may be working in a field that didn’t exist 20 years ago, such as mobile device development, or your job may be so specialized that non-technical people will never understand. Now that my job title […]
2018-11-05
153 reads
Today Kathi talks about the skills that all of us need to succeed in our careers.
2018-10-30
270 reads
Performance is a common reason to monitor SQL Server. The work day of a database administrator is often interrupted with unexpected calls about slowness in applications or reports. But, how does the performance today compare to the performance last week or last month? Can the root cause of the issue be traced to the database […]
2018-10-08
94 reads
With each recent version of SQL Server, Microsoft has added features that can be used to improve query performance with much less effort than traditional index and query tuning require. First was Query Store, introduced with 2016. When enabled, this feature allows you to easily find regression in query performance due to changing execution plans. […]
2018-05-21
132 reads
Back in my early days as a database administrator, almost 16 years ago, I happened upon a web site called SQL Server Central. Because I found so many useful articles and forum posts, the site was open in my browser at work every single day. It was a great source of information, and eventually, I […]
2018-04-23
166 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers