Identify SQL Accounts Without Password Policy Enforced
When ‘Enforce Password Policy’ for SQL Server logins is turned off, you can make your password anything you want! Hooray!...
2017-03-02
499 reads
When ‘Enforce Password Policy’ for SQL Server logins is turned off, you can make your password anything you want! Hooray!...
2017-03-02
499 reads
In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...
2017-03-02
434 reads
Log shipping provides a means to maintain a secondary server on an automated basisusing a chain of transaction log backups. This chapter explains the basic confi guration oflog shipping...
2017-03-02
37 reads
Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups....
2017-03-02
21,723 reads
A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
Related Posts:
When Too Much is Not a Good Thing December...
2017-03-02
107 reads
EZ PZ Permission Squeezee
Given the critical level of importance related to permissions, one may think it is a concept that...
2017-03-02
1,463 reads
OK, for no particular reason at all or maybe because I had too much food at lunch or just because...
2017-03-02
400 reads
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
387 reads
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
421 reads
This question gets asked a lot and reoccurs over the years. Do you need a degree to be DBA? I have seen...
2017-03-02
443 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