Given the headlines, the news we find out about companies not disclosing security issues, the back doors and poor code in much software, is it any wonder that people think it's a "when" and not an "if"? Given the lack of realization from many companies that suffer incidents that they were even attacked, perhaps that's an assumption worth making.
We've been hacked at SQLServerCentral in the past. I don't think we've been hacked in many years, but I also have no way of knowing. That's the difficult part of dealing with bits. If they get copied, there's not necessarily a trace of anything amiss. It's quite possible that many of us have no idea that our bits are being copied. Every read is a copy of data and how long did the NSA read data without most of us being aware? How sure are we that they, or some other organization, hasn't been reading much more than was disclosed?
I'd hate to think that our systems are so porous that we're all likely to get hacked at some point. It's probably technically possible, but hopefully not likely for most of us. However we should consider that it will happen and ensure we have some handle on our data security. It's hard, and complex for most of us, and I'd like to think that Microsoft will recognize this and build better controls and features into future versions of Windows and SQL Server that enable easier auditing, granular controls and separation of duties.
This article demonstrates how to selectively channel records from a flat-file data source to separate destination tables in an SSIS package using a combination of multicast, data-conversion and conditional-split data flow transformation elements within a data flow task. More »
PowerShell provides a command-line shell and scripting language (built in the .NET Framework) especially designed for administrative task automation and configuration management. Learn how to manage Windows services related to SQL Server, either on a local machine or remote machine, using PowerShell cmdlets. More »
Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.
Okay, you need Adventureworks, on a instance you don't care about or you will want to wrap the deletes in a transaction and rollback.
Run statement one:
SELECT TOP 10 'DELETE FROM [AdventureWorks2012].[Person].[BusinessEntityAddress] ' + CHAR(13) + 'WHERE [BusinessEntityID]='+CAST([BusinessEntityID] AS VARCHAR(50))+ CHAR(13) + 'GO'
Run statement two:
SELECT TOP 10 'DELETE FROM [AdventureWorks2012].[Person].[BusinessEntityAddress] ' + CHAR(13) + 'WHERE [BusinessEntityID]='+CAST([BusinessEntityID] AS VARCHAR(50))+ CHAR(10) + 'GO'
When you copy the results and paste in a new SSMS query window, which Deletes will successfully execute?
The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.
Please change the database name as per your requirement.
In below example I used the MiteshProd as Prouction db and Miteshdev as dev enviroment
CHAR column concenation
- Hey gang,
I'm a little stumped here. I want to concatenate character data from a table.
[code="sql"]declare @ttest table
(nItem integer not null,
ctext varchar(32) not null)
Use of create statistics
- What is the use of create statistics ?
I am having a DB With AUTO_CREATE and AUTO_UPDATE for statistics ON, then...
Need Query for summarizing data
- Hi there,
I need query for the attached output
create table #Wholeseller ( wsid varchar(100),[Productid From] int, [Productid To] int, units int)
create table #Retailer ( retid...
Aliases in OPENQUERY
- Hi All
I have the following query
(TAIL([Time].[CalendarMonth].[Year],1), [Time].[CalendarMonth].[Month]),4),3) ON COLUMNS,
([Game].[Game Code].& ,
FROM [CQGaming]') AS [KPI][/code]
Need assistance with XML
- Hello all,
I have a table which contains an XML column. This column is set up as "<properties><propertyName1>Value1</propertyName1><propertyName2>Value2</propertyName2>" etc...
I also have...
Table Size Query
- Hi Experts,
I'm using Ms SQL Server 2008 R2 (Enterprise edition), I need some help in compiling the correct SQL query...
generate random value before @ in email address
Here is my table,
[sup]CREATE TABLE test_43(id int, email varchar(50))
INSERT INTO test_43 VALUES (1, 'email@example.com')
INSERT INTO test_43 VALUES (2, 'firstname.lastname@example.org')
SELECT * FROM...
Fill in the gap between 2 number range
- In my SQL Server database, I have table with the following records
Let's assume that I input...
Help need in Avoiding Loop
Here is my table structure:
;with Users as
select 1 as UserId, 2 as PendingAmount,10 as AvailableAmount union all
select 2 as...
PageFile.Sys Size and Virtual Memory Size
- On one of my server the output of sys.dm_os_memory is as below
At windows (Computer-> properties->advanced->VM-> it is set to be...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.