Adding the ReadyRoll Extension in VSTS
As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.
A few...
2016-07-19
708 reads
As I’m doing a little development with ReadyRoll, I’m documenting some of the things I learn about the product.
A few...
2016-07-19
708 reads
The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month...
2016-07-19
361 reads
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the...
2016-07-19
671 reads
…I’m about to find out.
Continuing with the July training programme, this week I producing Learning Tree course 918 Agile Fundamentals:...
2016-07-19
465 reads
In Memory OLTP (Hekaton) introduced in SQL Server 2014 is a new database engine component which is optimized for OLTP...
2016-07-18
710 reads
Have you ever tried to query the contents of the default trace and then spent more time trying to figure...
2016-07-18
483 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-07-18
332 reads
In this module you will learn how to use the Dot Plot Power BI Custom Visual. The Dot Plot is...
2016-07-20 (first published: 2016-07-18)
2,371 reads
One of the things that you need with a Continuous Integration server is that ability to build your software on...
2016-07-22 (first published: 2016-07-18)
1,500 reads
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch...
2016-07-18
23 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...
Telp/Wa 628217555651 Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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