SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Data Security Policies

Does your organization have some policy around data security on mobile devices? Do your fellow employees care about data security? A new study says that most organizations don't, and potentially that's an issue.

Many of us are data professionals, and we might have no idea how much data a user can access using today's modern mobile devices. Potentially we can help them understand that the $500 smartphone they use can actually contain and access much more than $500 worth of data. If their device is the cause of a data breach, the cost could easily be much closer to $50,000 than $500.

Security is always a big gamble, and rather than the old models of controlling all devices and limiting access, we need to learn to educate users, work with them to secure their devices and report losses quickly. The survey shows that most employees don't even know how to report the loss of a device that might cause a data breach. At the very least, we can establish some procedures that will allow an account to be quickly turned off. And to ensure productivity doesn't suffer, we need a procedure that also engages a new account for a user quickly.

My guess is a lot of security issues could be handled quicker if we ensured that users were aware of issues and penalized for ignoring them, but made sure those penalties were balanced with an understanding that there it is inevitable people will make mistakes and accidents. Forgive mistakes and ask for reports of potential issues quickly.

Steve Jones from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 1.8MB) podcast or subscribe to the feed at iTunes and Mevio . feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Everyday Jones

Follow Steve Jones on Twitter to find links and database related items and announcements.

ADVERTISEMENT
SQL Backup

SQL Backup Pro “It just works”

The SQL Backup step-by-step wizards and a centralized GUI take the legwork out of creating, restoring, and verifying your backups. Check it out for yourself with a free trial.

Tortoise SVN eBook

Free ebook "TortoiseSVN and Subversion Cookbook - Oracle Edition"

Use these recipes to work better, faster, and do things you never knew you could do with SVN. If you're new to source control, this book provides a concise guide to getting the most out of Subversion. Download it free

SQL Prompt

5 ways to code effortlessly

Discover the different ways you can make writing, exploring, and refactoring SQL code refreshingly effortless with SQL Prompt 6. Download a free trial.

Featured Contents

 

Improving Performance for Some LIKE “%string%” Searches (SQL Spackle)

Dwain Camps from SQLServerCentral.com

If you've ever wondered if you can do better than an INDEX SCAN when you do a LIKE "%string%" search, read on... More »


 

Load Testing in a Big Data Environment

Additional Articles from Database Journal

Load tests give the database administrator quite a lot of valuable information and may make the difference between poor and acceptable application performance. But are there any gotchas or traps associated with big data? More »


 

From the SQLServerCentral Blogs - Database Design Guidelines For Developers

Andrew Pruski from SQLServerCentral Blogs

One of the developers that I work with asked me to write a “brief” (really brief) guide on database design.... More »

Question of the Day

Today's Question (by Shanjan Sapra):

What is the surest way to check that your syntax is valid and will work with SQL Server?

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: syntax.

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

SQL Server 2012 AlwaysOn Joes 2 Pros®: A Tutorial for Implementing High Availability and Disaster Recovery using AlwaysOn Availability Groups

SQL Server 2012 brought in some great new features and one of the important ones is scalability and performance via AlwaysOn. AlwaysOn is a superset feature and is a combination of many things you will learn about. As the language suggests, this technology achieves a SQL Server infrastructure that can be "always on". For businesses that run 24x7 downtime means the loss of business. This type of risk is out of the question for these businesses. This book discusses in detail the concepts of SQL Server AlwaysOn starting from the basics.

 

Yesterday's Question of the Day

Yesterday's Question (by free mascot):

Is it possible to create more than 1 distribution database for replication on a SQL instance i.e. distribution, distribution1 etc. on SQL Server 2012?

Answer: Yes

Explanation:

The correct answer is Yes.

I did not find any Microsoft article on this. However refer the following link for distributor related informations: http://technet.microsoft.com/en-us/library/ms151860.aspx

You can do so by navigating on Management Studio of a server which is having distributor database:

1. Open Distributor properties... by right clicking replication folder.
2. Click on general tab > right pan you can see the Distribution Databases and Databases: you can find the distribution databases
3. Click New... icon to create new dristirbution database and click OK.

Here you go.. You have created another distribution1 database.


» Discuss this question and answer on the forums

Featured Script

Identify Column Data Types

Rich Yarger from SQLServerCentral.com

--The following offers a result set for just the Database, Schema, Table Name, Column Name, Data Type, and Maximum Character Length from information_schema.columns.
select TABLE_CATALOG AS 'Database', TABLE_SCHEMA AS 'Schema', TABLE_NAME AS 'Table Name', COLUMN_NAME AS 'Column Name', DATA_TYPE AS 'Data Type', CHARACTER_MAXIMUM_LENGTH AS 'Max Length'
from information_schema.columns
WHERE DATA_TYPE = 'ntext'
--Will provide a count of 'text type' data type columns.
select COUNT (DATA_TYPE)
from information_schema.columns
WHERE DATA_TYPE = 'nvarchar'
OR DATA_TYPE = 'varchar'
OR DATA_TYPE = 'nchar'
OR DATA_TYPE = 'char'
OR DATA_TYPE = 'text'
OR DATA_TYPE = 'ntext'
--Full query, and just a good place to start.
select COUNT (*)
from information_schema.columns

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2014 : Development - SQL Server 2014

Rolling 12 month/Period SQL Query Logic - I want to write rolling 12 SQL query with following data , input will be FY and period no ie @FY=14,...


SQL Server 2012 : SQL 2012 - General

data sql server 2000 to sql server 1202 - I have a windows server 2000 and SQL Server 2000. how to move the data from sql 2000 to sql...

Debugging in SSMS - Recently, I added SQL 2012 to my machine. The 1st time I tried to debug, it asked me about opening...

simple store procedure - Hey Guys, I am using SQL Ser 2012 and using adventureworks 2012 db. I am creating a simple SP wherein I search...

Is SQL Replication to Oracle databases being deprecated? - I heard that SQL Replication will no longer work with Oracle is this true? If so then is it starting...

Installing a clustered SQL 2012 instance is extremely slow - Wonder if anyone has experience installing SQL 2012 on an existing Windows 2008 R2 cluster with several SQL 2008 R2...


SQL Server 2012 : SQL Server 2012 - T-SQL

Geometry - Parallel lines - Hi, Assuming I have a line, is there a function I can call to create a parallel line at a given...


SQL Server 2008 : SQL Server 2008 - General

Return-path email header - Is it possible to set the Return-path header when sending an email from SQL Server? sp_send_dbmail doesn't seem to provide for...

Number of columns in table - I've been researching issues on the number of columns in a table vs performance. I have a Customer table, 87 columns,...

generate insert statement from table - I have a table with the following columns: customnr number wk1 wk2 wk3 wk4 1200 20 5 6 7 8 1300 10 4...

Seeking Expert Advice For Reporting - Greets! I'm an accidental DBA that's helping design a new BI solution for my current employer. Although this sounds kind of...

how can i set up windows event log notification through mail using SQL server - how can i set up windows event log notification through mail using SQL server. Scenario: i have to audit an specific eventid...

Urgent help with STRING in SQL - Hi friends, I need a urgent help with SQL String validation please- I have a field in DB that is nvarchar(500) named...

Long-running query with no impact on the server - I have a view which is a union of three select statements. It ran ok before but now it ran...


SQL Server 2008 : T-SQL (SS2K8)

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...


SQL Server 2008 : SQL Server 2008 Administration

Manually update backupmediafamily - I took a manually log backup and missed a folder name in the path. to disk = "d:\folder\folder2\log.trn" instead of "d:\folder\folder2\folder3\log.trn" If I...

SQL Server on domain or workgroup - Hi Friends, I am a bit confused between domain and workgroup. What is the limitations if we run out windows boxes on...

Opinion of use of LINQ - I have a new developer that recently started. He is using LINQ and he approached me on some performance\connectivity issues which...


SQL Server 2005 : Administering

Options for continuously moving data from 2005 to 2008R2 for a single table - We have a SQL Server 2005 instance that hosts an OLTP environment for our finance system (Navision). We have CRM...

trigger to audit - Hi, I need to create triggers to audit some of my tables. I want that all changes made to this tables that...


SQL Server 2005 : Business Intelligence

Processing flat file with Header,Detail and Trailer - Hi All, I have below flatfile.Please let me know how to process this file without scripttask in SSIS. I need...

SQL Server Agent - SSIS Package Fail as the connection cannot be seen by the Agent - Hi All I am really struggling to find the source of this issue. I am using SQL Server 2012 with Visual...


SQL Server 2005 : Development

Query Active Directory from SQL - We need to be able to get the active directory SID for a user logged into SQL using Windows Authentication...


Reporting Services : Reporting Services

No users can Print SSRS reports - They get Error loading resource library. (0x8007007E). deleted rsclientprint*.* from windows/system and windows/ reinstalled to c:\windows\downloaded program files\ Still the same...


SQLServerCentral.com : Anything that is NOT about SQL!

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...


SQLServerCentral.com : Articles Requested

Avoiding Cursors - After seeing this: [url]http://www.sqlservercentral.com/Forums/Topic1546354-391-1.aspx[/url] I'd like to see some articles that look at real situations where you've replaced a cursor (or...

Format results as HTML table w/ powershell - It's easy, but a reference that shows beginners how we take some data, perhaps performance or other data in a...


Microsoft Access : Microsoft Access

reference recordsource on subform - I have a form with 3 subform. On Currrent event on subform1, I am getting the ID and then using...

This email has been sent to {user_email}. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
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 ©2014 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com