New Job -> Week 1 -> What Tools Do You Need?
I changed to a new job and started it this week. Before I started, I thought of all the things I thought I would want to do when I...
2023-04-05 (first published: 2023-03-17)
439 reads
I changed to a new job and started it this week. Before I started, I thought of all the things I thought I would want to do when I...
2023-04-05 (first published: 2023-03-17)
439 reads
Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking about SQL Server Availability Groups.
2023-04-05 (first published: 2023-03-21)
264 reads
There is a survey from the WIT group for female speakers. If you are a woman and speak in front of groups, or used to, please fill it out....
2023-04-05
61 reads
Zach's 1st MegaCon 2011 Hello Dear Reader! This past week is a blur. It was a tough week at work. That sentence is an understatement, but its really all I...
2023-04-04
54 reads
Today we have announced the schedule for Data Céilí 2023 and have opened registration! We have two days of great sessions for you, the 8th of June will have...
2023-04-03
45 reads
The grade for March is also D. Details below, but just not making a lot of progress in these areas. In fact, I find myself not motivated to work...
2023-04-03
35 reads
Data continues to be the lifeline for companies across the globe. As maturity levels continue to grow across companies, one aspect that sometimes needs to be checked is cataloging...
2023-04-03 (first published: 2023-03-20)
276 reads
If you have read any of my last few posts on provisioning Azure Data Explorer then you will probably be wondering….. Will he write about Powershell? Ok, I will....
2023-04-03 (first published: 2023-03-20)
233 reads
This is part of a series of new job blog posts. You can find them all here. The main goal for week 3: setup much needed alerts on DTU...
2023-03-31 (first published: 2023-03-30)
202 reads
I had an amazing time adventuring to Wales with other members of the data community last week! It was my first international conference, and I had heard so many...
2023-03-31 (first published: 2023-03-23)
282 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