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

PVPs

I had it happen to me. We had an SSL certificate for a website that one of my employers ran. I actually purchased the certificate, and it secured our communications for a couple years until one day it didn't. The certificate expired and the website stopped accepting connections. If I had noticed, it might not have been a big deal. However when the owner of the company gets a call from one of his large customers, it's an much bigger issue.

If you worked at Microsoft last year when their security certificate expired, it was an even bigger deal. It's not that an affected customer that sends a note; it's affected, unaffected, and potential customers that hear about the issue from the media. It seems like tracking private virtual properties (PVPs) ought to be easy, but it's not. As pointed out in this piece, there are a number of issues at an organizational level, and while there are fixes, it takes some effort.

In many businesses that have periodic activities required for physical assets, there are often people dedicated to tracking, or performing the activity. Mechanics know about maintenance on vehicles, accountants renew leases, workers replace equipment nearing the end of service. Often the time lines and activities involved are understood, and individuals understand their responsibilities.

This showcases another area in which technology is woefully immature. Need a certificate? It takes a person with specialized knowledge to understand what's needed, purchase it, and install it. This person either then moves on to a new role without leaving instructions behind, or isn't well equipped to understand the need to track the expiration and replacement of the technical item. There often isn't even a system set up to handle replacements of these items, which might be superseded or replaced by some entirely new type of technical wizardry.

Managing and tracking PVPs is hard, and I suspect, going to get harder. Security requirements increase, technical requirements grow, and specifications change. I'd like to say I'm confident Azure (or AWS or another large service) will never have another outage because of this, but I wouldn't be surprised if they do.

Steve Jones from SQLServerCentral.com

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


Video and Audio versions

Today's 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.

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

Steve Jones

Windows Media Video ( 20.5MB) feed

MP4 iPod Video ( 23.9MB) feed

MP3 Audio ( 4.9MB) feed

Feeds are available at iTunes and Mevio

To submit an article, rant or editorial,
log in to the Contribution Center

ADVERTISEMENT
antsmemoryprofiler

Can you spot the 4 most common .NET memory problems?

Red Gate’s Beth Aitman looks at 4 common types of .NET memory problems and how to fix them. She covers the symptoms, how to investigate each problem, and possible solutions. Read this new article.

Deployment Manager

Deployment Manager 2 is now free!

The new version includes tons of new features and we've launched a completely free Starter Edition! Get Deployment Manager here

SQL Monitor

Get alerts within 15 seconds of SQL Server issues

SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Featured Contents

 

DAX Query Basics

Gary Strange from SQLServerCentral.com

In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube. More »


 

Cambridge, UK - SQL in the City Seminar - Deployment Stairway

Press Release from SQL in the City

Grant Fritchey, SQL Server MVP will be hosting a free seminar in Cambridge on January 10 2014. Join fellow database professionals to learn tips and best practices for SQL Server version control, continuous integration and deployment. More »


 

How to find user who ran DROP or DELETE statements on your SQL Server Objects

Additional Articles from MSSQLTips.com

Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this information. More »


 

From the SQLServerCentral Blogs - Exploring Excel 2013 for BI Tip #12: Icon Sets

DataOnWheels from SQLServerCentral Blogs

As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly... More »


 

From the SQLServerCentral Blogs - Power BI for Office 365 requirements

“Power BI” is an umbrella name for a lot of products, which I explain at Power BI first impressions (also I have... More »

Question of the Day

Today's Question (by Steve Jones):

I create a Central Management Server on SQLSales1. I then create a group and add SQLSales2 and SQLSales3 to the group. I want to execute a query against all three instances and decide to run it using my group on the CMS. What happens?

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: Central Management Server (CMS).

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

Microsoft® SQL Server® 2012 Step by Step

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.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

If I wanted to get help with indexing recommendations, which of these command line tools would I run?

Answer: dta.exe

Explanation:

The correct answer is dta.exe. This is the database tuning advisor utility that can take a workload and output index recommendations.

Ref: dta.exe - http://msdn.microsoft.com/en-us/library/a0b210ce-9b58-4709-80cb-9363b68a1f5a


» Discuss this question and answer on the forums

Featured Script

Smart Index Rebuild - All Databases

Tim Hollobon from SQLServerCentral.com

Use in your maintenance plan when you need to rebuild indexes in all databases but it takes too long to do every single index in every database, and be too hard to maintain a specific list every time another database was added or removed. With this script you can do the whole instance but only where the index fragmentation is above a specified threshold.

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 : Administration - SQL Server 2014

Maintenance task error - I just started having an issue with maintenance tasks. When I click on one of my jobs to modify it...

Can not enter in sql server under sa - I had by default installed express msmss with windows mode. But now I need mixed mode of authentication. I have...


SQL Server 2014 : Development - SQL Server 2014

odd situation - How can u have the same tablename in sysobjects w/ different id's. It's making one of my processes fail. The...

Null instead of 0 - Friends, I have a excel sheet with some data and blank columns. I have a ssis package using to import...

Column data type I'd like to see in SQL Server 2014 - [code="sql"] [SPACETIME] nvarchar(INFINITE) [/code]


SQL Server 2012 : SQL 2012 - General

Union Join between 3 SQL Queries - I am looking to perform a UNION join between 3 select queries, this is what I think I need to...

Data Dictionary - Hi, I need to get the data dictionary for the database tables that are related to users and orders(Users table and...

Identify a cursor and see the command text - Hi I've got a little performance problem since a few days, which is most likely caused by a cursor. It pops up...

SQL Server 2012 Memory Problem - I am doing some research on a production server that we have that is essentially choking on a some simple...

Cannot set up alias for named instance - Greetings, I am trying to set up an alias for the SQL Server 2012 named instance (the default instance is 2008,...

SSIS - Date conversion in SQL Server data source - I'm executing a stored procedure that is doing a straight forward date conversion from an integer in YYYYMMDD format to...

Design / performance question - I have a large fact table (several millions of rows) in my data warehouse. I want to add a dimension...

Problem Saving SIS Import Package Using Import and Export Wizard - I often have to import data from a CSV file into SIS. I have been doing this manually, using the...

Transactional publication with updatable subscriptions on SQL2012 release. - Hi, We have a 4 serves around the world that needs to be in updatable subscriptions. Server location & versions: 2 servers...

AlwaysOn AG for DR - Hi everyone. I have a design question about SQL Server 2012 AlwaysOn availability groups when used for DR purposes. I built...

checkdb and snapshots - Hi, The system is SQL Server 2012 SP1 Enterprise Ed 64-bit 11.0.3349.0 Integrity Check has been failing on random user databases and...

SSMS 2012 error when connect to sql server with windows authentication after VS instalation - Hi. After install VS 2012 in my pc i can't connect with SSMS 2012 to my SQL Server 2012 server (i...


SQL Server 2012 : SQL Server 2012 - T-SQL

Set based super challenge - Please read the attached txt file. The challenge is to summarize the data per patient but only as / if the consultant...

differences in rounding / converting strings - Hi all, first of all: I know some best practices and work-arounds when working with float numbers, I just want to...

Merge - Pros and cons - Hi there, Please any one help me out to understand what is MERGE ? and when to use it? Also explain me the...


SQL Server 2008 : SQL Server 2008 - General

Sequence in PDW 2008 - I apologize if this is not the correct forum. I am trying to determine if sequences (as in SQL Server...

What are the implications of the error “The transaction is in doubt” - One of our applications has reported the error in the ADO.NET stack “The transaction is in doubt” when the SQL...

Enable xp_cmdshell service - I Did enable this but still error comes.. We have a SSIS package & we want to execute it via SQL agent...

User requirements for SQL 2008 - Hi Guys, wonder if you can help me? I have a user who is able to read information from production databases....

I have multiple identifier Could not be bound when I use ROW_NUMBER() - Hello I want to have paging in my list. I use code below [code="sql"] declare @string nvarchar(MAX) declare @UserMidListTable Table (Id Int,Mid...

SQL 2008 - Copying Maintenace plans to new server - how can w e move maintneace plans from SQL 2008 to another SQL 2008 server. I can export the package...

add the internal email field to the view - How to add add the internal email field to the view on a database ?

Could I use NOLOCK in this situation - Hi All, Lately we have been experiencing a fair amount of blocking issues in our DB and some of it down...

Which Datatype should I use?? - I want change the data type of my Table. It has a Weight column with following description [Weight] [numeric](9, 4) NOT...

What is the Difference ? - Hi, Recently I got to execute one query which comprise the CASE statement as below, though the condition within the...

SQL 2008 cluster - Copy All SSIS Packages to Disk - On windows 2008 clustered sql am running below command to move a package from msdb to folder in another server. dtutil...

Error in maintenance plan history cleanup task (exec msdb.dbo.sp_delete_backuphistory) - Hello Friends, I got one Strange Error [b] "Executing the query "declare @dt datetime select @dt = cast(N'2013-10-11T14:40:53' as datetime) exec msdb.dbo.sp_delete_backuphistory @dt "...

Wait type - PREEMPTIVE_SP_SERVER_DIAGNOSTICS very high - If this wait type "PREEMPTIVE_SP_SERVER_DIAGNOSTICS" is very high what does it mean? What's the downtime of such signal if this is...

Purpose of turning on cross db ownership chaining - Hi, Wanted to know a best scenario when one must turn on the feature of "cross db ownership chaining" in sql...

Is SQL crashed??? - When i open SSMS i can see multiple File, Edit, Tools option on toolbar..:w00t: What to do.. Displaying weird

Starting one named SQL Server service stops/crashes another - Hi all We currently have a machine running a named instance of SQL Server 2008 and need to create a new...

Need to query db user access history - Hello, i've been trying to find out user access history on a particular DB. I used a query which returns...

Help with a multiple selection Parameter and a Case statement - I would like to create a multiple selection parameter to run in the WHERE clause for different conditions. I would like...

Update Cursor Advice - Hi, I have two tables Main & OrderReturn [code="other"] CREATE TABLE [dbo].[Main]( [orderID] [varchar](15) NULL, [orderLine] [int] NULL, [mpn] [varchar](25) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[OrderReturn]( [orderID] [varchar](15) NULL, [orderLine]...

script to add an article to replication process does not work - only works thru GUI - need help - Hello everybody: I have a transactional replication process going on. Want to add 1 more article to the replication process, need...

user initiated agent jobs / concurrent job runs - Currently we have an agent job that runs an SSIS package on a schedule and produces reporting data needed, but...

Backup & Restore - I am trying to restore SQL 2012 backup on SQL 2008 R2 & it troughs an error. Error: No backupset selected to...

replace null or empty values with default date - Hi Friends i have small doubt in sql server how to handled null or empty value and replace through default...

The clocks on the client and server machines are skewed - Hi all, When running SP which read data from remote server (linked server), after few minutes, I get the following error:...


SQL Server 2008 : T-SQL (SS2K8)

How to Pass date dynamically ... - I have an table which contains lots of transaction with a column called Validity which is a boolean(True or False). Now...

Can table-valued parameter be null? - Hii Guys, I'm new to table valued parameters -- admittedly a little late but better late than never. I'm trying to insert some...

Must Declare the scaler variable @mesg_out - I am trying to execute the dynamic sql query and getting the following error: Must declare the scaler variable @mesg_out. I already...

Barcode font 128b -SQL function - Hi, I am looking for an SQL function that will generate the correct characters to make barcode font code128 work when...


SQL Server 2008 : Working with Oracle

Pass a parameter to OpenQuery? - Why does not the four-part naming convention work?!? I need to pass a parameter and am struggling to make this work...


SQL Server 2008 : SQL Server Newbies

Finding the MIN and MAX date - How do I approach this? - I have a table with the following data: [code="sql"] EMPID EffectiveDate PrimaryRater 12345 10/10/2001 A12345 12345 07/12/2013 A12345 12345 08/18/2002 A12345 12345 07/17/1966 A12345 12345 01/01/1966 B12345 [/code] What I want to do is...

SELECT question - I have 2 tables. Each one has the following columns: SSN, PKT and FICE_NBR. I need to be able to retrieve...

Using REPLACE - Hi I have a requirement where I have replace two different strings with another string. i.e. if there is 'Brigade Army or...


SQL Server 2008 : SQL Server 2008 High Availability

Replication- distribution server crashed - What are the options of setting up the replication without configuring it from the scratch when distribution server is crashed....


SQL Server 2008 : SQL Server 2008 Administration

Auditing to fetch the details of lastlogin date of user in SQL server - How to use auditing to get the lastlogin date of the user in SQL?? or is there any other way to...

Production databases, people involvement - I work in a small company with 90 people. I have been working as a database developer but recently started...

Understanding heaps - Hi, Can anyone explain the below behavior for HEAP tables? I have created a small heap table with 3 rows which...

SQL Jobs failed - Unexpectedly? - Hi Recently SQL 2008 edition upgraded to enterprise edition from standard edition on top of windows 2008 server 32 bit operating...

Backup With Checksum - In searching for information on checksum, I see statements like "When backing up a DB Checksums are checked for pages that...

CPU considerations for multiple instances - I've been researching this and haven't found much info so I'm not sure what most people do. Consider a server...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Stored Procedure Running Slow via SSIS vs Management Studio - I've been having some pesky tuning problems with Stored Procedures running via DTEXEC and through BIDS. When I run the stored...


SQL Server 2005 : Administering

Using RTM installation Media after applying the service pack for SQL Server - There is a requirement to install Client components which are not installed on a MS SQL Server Installation. As of...

"Public" roles - Hi guys, A bit new in SQL, and I was just wondering if someone could tell me what roles exactly got...

Bulk insert issue - Hi All, I am getting problem on bulk insert issue through SSIS package. when bulk of the record inserting in the particular...

Copying a SQL Server Instance on other Machine - We would like to copy the SQL Instance to other machine. Is there a export Import utility I can use it...

copy job fails - Hi All, I have copy job Problem in Log Shipping, the copy job failed, but when i see the restore job...

fillfactor - what is fillfactor and what are the advantages and disadvantages?


SQL Server 2005 : SQL Server 2005 Performance Tuning

will Collocation help in following situation. - Hi, I was trying to partition my tables , and also read about Collocation. q1) I would like to know whether i...

Memory Buffer says table occupies upto 6x more memory space than physical table size - I am trying to investigate SQL Memory usage and am running the query below However for one core table (item) which...


SQL Server 2005 : SQL Server 2005 Integration Services

SSIS subsystem failed to load - Hi On this server we are using SQL Server 2005 SP4, with a number of instances and the same issues is...


Reporting Services : Reporting Services

Conditoinal Formatting on Percent Field Not Working - Alright, I'm feeling really dumb having to ask this question as i've done this a thousand times, however I can't...

SSRS Parameter Controlled Drill down - Hi, I have a SSRS report which has a Drill-Down via our Date Dimension, and shows a measure at the year,...

ssrs 2012 show hide parameter area - In an existing SSRS 2012 application, there is an up or down area that appears sometimes in the paramneter area...


Reporting Services : Reporting Services 2008 Development

Aligning two subreports to the width of the parent report - I'm struggling to get two subreports that sit side-by-side on a parent report to match the width of the parent...

Page Header Issue - Hi guys, I have a table in my report with the following details, Employee (Consists of Expression Employee Id and...

Hyperlink - I added a URL in actions to direct my report to another one. However , I do not see a "hand " icon...

Display secondary axis values on right of chart - I guess I'm missing something really obvious, but how do I move the secondary charts axis labels to the right...

Exporting SSRS reprot to Excel - Hi Team, I'm exporting a SSRS report to Excel. For some input parameters the number of rows generated by the SSRS...


Programming : Powershell

PowerShell module into SQL Server - Hello, I'm trying to find a way to burry my PS module into extended stored procedure(XP) in sql server. Any help...

Server 2003 powershell - What version of powershell ships with Windows Server 2003?


Data Warehousing : Integration Services

bulk insert operation through SSIS package. - Hi All, I am getting problem on bulk insert issue through SSIS package. when bulk of the record inserting in the particular...

Unable to access SQL Server instance alias as connection manager - Greetings, I have been handed a Visual Studio project containing about 30 ETL's. The connection managers use aliases instead of specific...

SQL task is not running when I pass one parameter via variable and the other 2 hard coded - exec [dbo].[sp_EmailNotification] ?, 'General Ledger - Department Integration Failed', 'Truncation of the Departments General Ledger Table Failed' On the parameter mapping form I...

How to create variable for @startdate and @endDate in SSIS Execute SQL Task - I have a simple query that provide me with all the previous month data using the FilecreationDate Declare @StartDate varchar(8) Declare @EndDate...


Data Warehousing : Analysis Services

Reporting Help (Excel, SSRS, MDX) - I have built my first cube and I believe it is setup properly but I am having hard time wrapping...


Database Design : Design Ideas and Questions

Has anyone used the Data Vault model to build ODS prior to building DDW - I am being tasked with building two datamarts in SQL2012/SSIS in the next few months. The first is an Enterprise...


Database Design : Relational Theory

Database without ANY primary keys - Hi all, I work with a database that has no primary keys defined on any tables. As a customer's consultant I...

Dumb Vocab Question about What This Type of Table is Called - This is probably a dumb question, but I'm totally self-taught and have learned everything I know from the Internet, so...

Circular reference - Is it valid design for TableA to reference TableB (foreign key) and TableB to reference back to TableA (foreign key)?...


Database Design : Hardware

San storage - I have a question regarding san storage and partitions

Equallogic, SQL and VMware - Hello, Sorry if the question sounds silly... I know and understand it's best practice to seperate log, data and temp files...


SQLServerCentral.com : Anything that is NOT about SQL!

is the newsletter mailing broken? - I haven't gotten the newsletter in my email for a couple of days now, is it broken or is there...

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

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 : SQLServerCentral.com Announcements

SQLServerCentral Member Levels - Updated 2010/06/10 - Here are the current levels: [code] Forum Newbie 0 Grasshopper 10 SSC Rookie 25 Valued Member 50 SSC Journeyman 75 SSC-Enthusiastic...


SQLServerCentral.com : SQLServerCentral.com Website Issues

Not receiving daily newsletters - Has anyone else stopped receiving the daily newsletters via email? The last one I got was Friday 15th Nov.


SQLServerCentral.com : Suggestions

How do I add an image to my post? - There are opening and closing tags of '[img]' and '[/img]'. How do you use them (or is there another way)...


SQL Server 7,2000 : Administration

Need to Defrag Indexes Without Writing to the Transaction Log - Every weekend we defrag our indexes on our primary ERP database. It takes about four hours. I run about 4,300...


SQL Server 7,2000 : Backups

Problem in database restore - Hi all, I am getting following message when trying to restore a newly created database with existed backup file file. I...


Microsoft Access : Microsoft Access

Tab control inside a Tab Control - I want to put a tab control inside another Tab Control. I have 10 tabs on the parent tab control....


Notification Services : Administration

Query For Lower Case f - Hi All, Plz help me out for query for the lower case data.Our company having data for file and file numbers...

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 ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com