Great Value IT Training - Awesome ITIL offers
This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have...
2016-09-15
387 reads
This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have...
2016-09-15
387 reads
Introduction - Detecting and Monitoring Memory Pressure
I will be writing this article in four parts because this
topic is huge and amount...
2016-09-15
489 reads
The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use...
2016-09-15
501 reads
I do not say you should be expert in other technologies but you should be aware of what it is...
2016-09-15
393 reads
My wonderful friend Chrissy LeMaire and I are the creators of two GitHub repositories for SQL Server and PowerShell called...
2016-09-14
783 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-09-14
523 reads
My life for the last 2 years has been a constant battle of putting out fires with system performance; finally...
2016-09-14
349 reads
This is just a quick reminder to encourage you to attend my next round of all-day precon training session at the...
2016-09-14
409 reads
Just a quick blog post about an error I recently encountered when trying to create a mobile report for SSRS...
2016-09-14
709 reads
Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So...
2016-09-14
524 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