Guide for Set Up of Telegraf for Monitoring Windows
Problem
As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system...
2018-04-17
2,053 reads
Problem
As good DBAs, we sometimes have the need to monitor stats or just want to be nice to our system...
2018-04-17
2,053 reads
This T-SQL Tuesday is brought to us by Jens Vestergaard (b | t), and we are asked to share our favorite...
2018-04-10
690 reads
This T-SQL Tuesday is brought to us by Jens Vestergaard (b | t), and we are asked to share our favorite...
2018-04-10
78 reads
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
306 reads
Problem
For good database design, it is not idea to have everything in your PRIMARY filegroup so you can do partial...
2018-04-03
69 reads
Chicago O’Hare AirportI had two SQL Saturdays this month SQLSaturday Chicago and SQLSaturday Rochester both of which were very cold....
2018-04-01
284 reads
Problem
I’ve noticed on demo machines that sometimes Telegraf doesn’t start on the first try, and this seems to not happen...
2018-03-12
1,056 reads
I had two SQL Saturdays this month SQLSaturday Cleveland (which was very cold) and SQLSaturday Tampa (which had very nice...
2018-03-01
222 reads
Problem
We need a way to collect performance metrics for all our SQL Servers (Windows and Linux) into one system and...
2018-02-24
4,938 reads
This month Aaron Bertrand (b | t) has given us a Dealer’s Choice on the T-SQL Tuesday topic. I’m of course going...
2018-02-13
149 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