| A community of more than 1,600,000 database professionals and growing |
| | | The Opportunistic Hacker This editorial was originally published on April 14, 2015. It is being republished as Steve is on vacation. You're sitting in Starbucks, working. You need to use the restroom and you ask the hip, cool looking person sitting coding next to you, with whom you've chatted with for the last hour about C# and SQL, to watch your laptop. You leave and come back to an empty table. This was a hacker, coding away at their side job to pay a bills in between causing mayhem. They walked away with your laptop, not knowing if you work for a bank or a soy milk manufacturer. The hacker won't know if you have a copy of the production database on your laptop or simple a few .ASPX files that are useless without a VPN connection to your office. Hopefully that can't access other machines from yours. This is a crime of opportunity, and it happens regularly. Criminals steal laptops from coffee shops, airports, cars, and more. Often just because they can. Some may just wipe the device and sell it, but others may spend some time poking around to see if there is any value in the data on the machine. Or on a connected machine. Many of us have far too much data on our machines, with many, many saved passwords and connections. We have copies of code, databases, or backups, and losing our machine to a random criminal might be just as damaging to our organization as losing it to a hacker that targets us. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
|
| | ADVERTISEMENT | | | | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial |
| | | | Database migrations inside Visual Studio Feeling the pain of managing and deploying database changes manually? Redgate ReadyRoll creates SQL migration scripts you can use to version control, build and release, and automate deployments. Try it free |
|
|
|
| | | | | Daniel Calbimonte from SQLServerCentral.com This time, we will talk about the competition or alternatives to Azure SQL Data Warehouse. More » |
| | Additional Articles from Microsoft MSDN SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur. More » |
| | Additional Articles from SimpleTalk Data breaches make the news on an almost daily basis. There is no turning back, however, as we are firmly entrenched in this digital way of life. Brian Kelley discusses some of the reasons data breaches occur and what we can do to prevent them. More » |
| | Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Advance Card. The Advance Card is similar to the native... More » |
| | Arun Sirpal from SQLServerCentral Blogs Now that I have your attention with a powerful title how about some context? It is quite common to get... More » |
|
|
| | | Today's Question (by Steve Jones): What two types of collations can be specificed when SQL Server is installed? |
Think you know the answer? Click here, and find out if you are right. We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Collation. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | More than ever, the effective management of technology is critical for business competitiveness. For decades, technology leaders have struggled to balance agility, reliability, and security. The consequences of failure have never been greater?whether it's the healthcare.gov debacle, cardholder data breaches, or missing the boat with Big Data in the cloud. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have a job set that makes a backup of my SalesStatistics database every day. The filenames look like SalesStatistics_201806010100.bak and the backup job for this file would have looked like this: BACKUP DATABASE SalesStatistics TO DISK = 'SalesStatistics_201806010100.bak' WITH COMPRESSION, INIT, I find that I need to restore this backup to a new instance to run CHECKDB and have it available for any problems that occur. I run this restore command: RESTORE DATABASE SalesStatistics FROM DISK = SalesStatistics_201806010100.bak' WITH CHECKSUM, REPLACE What happens, assuming there is a SalesStatistics database on this new instance? Assume there are valid file paths in the backup file and on this instance.
Answer: The restore fails because the CHECKSUM option was not used during the backup Explanation: If a RESTORE option is run with the CHECKSUM operation, but the backup was not made with this option, an error is returned. The error will be: Msg 3187, Level 16, State 1, Line 3 RESTORE WITH CHECKSUM cannot be specified because the backup set does not contain checksum information. Msg 3013, Level 16, State 1, Line 3 RESTORE DATABASE is terminating abnormally. Ref: BACKUP - click here » Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| | Here's a few of the new posts today on the forums. To see more, visit the forums. Take Backup from SS 2017 to Older Version - I support a production database that was recently migrated to SS 2017. For years I have taken backups of that... Best method to reorganize sql server database - Hi, Which is the best method to reorganize sql server database. The purpose is to reduce the size of database and increase... Unable to connect from SQL Server Management studio 2016 to SQL Server 2008 R2 database Server - I am unable to connect to a database server running : Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) Aug 19 2014... Always on failover clustering - I'm a total rookie at clustering, so of course we will be starting a project requiring this feature soon. Are there... Always On Availability Groups Failover Question - Hi, I'm curious if anyone knows the answer to this off the top of their head since I'm not able to... Warning: No Join Predicate (Nested Loop) - Morning Guys, The following query is complaining about having no join predicate on a nested loop EDIT: The Operator Cost is 0%... Insert a duplicate copy of any record that meets certain criteria - Sorry for this dumb question but I am very new to SQL. Could someone help me write a SQL code? Please help - complete missing data with latest recorded - Hi there, I have been stuck on this for days and I need submitting this report in the next two days. This... Find the difference between 2 values - Experts, I am wondering if I can get some help with what I am trying to accomplish here. I have 2... Trying to pull data from a phone system Call Detail Report (CDR) - Greetings, I am not highly proficient in SQL as I'd like to be - I can get by but this latest problem... Preserving the total field lenght - Hello comunity I have a field Char(10) named bank, and another one Char(15) named namebank. I need to create a TSQL query,... How to read list of files in folder using T-SQL? - Does anyone know how to read files from spesific folder/path using T-SQL? Regards, Eko Indriyawan Transpose a particular row to columns - I am seeing lot of examples of PIVOT to do this, but my problem is different. I have a table like... "An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source" - Hi, I have a test SSRS server that currently only has one report on it, I can see the report when... SSIS: How to load a data from a table to a file, into 50 000 batches (50 000 rows at a time) - Hi, I have a table with 200 000 records, I need to send a file with 50 000 records. I'm using... Login failed for user 'NT Service\MSSQLServerOLAPService' 28000 - I am using SQL Server 2012 developer edition on Windows 7. I have the following error attempting to process a... Backup failuer with error 3132. - has anyone come across this error and any solution : Msg 3132, Level 16, State 1, Line 1 The media set has... Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction - Transaction (Process ID 59) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.... SUM of 2 columns in 2 tables THIS IS REALLY SIMPLE - I want to SUM a column in one table and SUM a column of another table and have the two... The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error. - Guys, I need help on the following please. i have stored the information 'birthdate' on the table candidates,as varchar. the birthdate... |
|
| This email has been sent to [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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. | This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: [email protected] |
|
|
