Which Secure Protocols are Allowed on Your Servers
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance.
This one...
2015-12-22 (first published: 2015-12-15)
1,808 reads
A script to have handy to tell you which schannel protocols are enabled / disabled for PCI or certificate compliance.
This one...
2015-12-22 (first published: 2015-12-15)
1,808 reads
In the West, the holiday season summons different memories and plans for different people. The thought of gorging on a...
2015-12-25 (first published: 2015-12-15)
1,027 reads
This is a temporary post that was not deleted. Please delete this manually. (621301ab-a053-48fc-a7ec-01dc1d5fe152 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2015-12-15
817 reads
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,756 reads
For the last part of the series on transactions, I’m going to look at a problem that I ran across...
2015-12-21 (first published: 2015-12-15)
2,586 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
192 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
220 reads
Here is some of the installation processes(https://thakurvinay.wordpress.com/category/installation/) Below is very nice step-by -step installation process for SQL Server 2016: http://www.databasejournal.com/features/mssql/installing-sql-server-2016.html
2015-12-15
982 reads
Ran into an issue where a developer was trying to create a database and was denied due to no ability...
2015-12-15
219 reads
2015-12-15
9 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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