For the time being, passwords are the way that we authenticate users and secure most of our systems. There might be a better system in the future, but for now everyone needs to manage a series of logins and passwords, even if you have authentication for many systems linked through an internal domain or external system, like OpenID.
I think password managers are almost required these days to manage passwords for most people. I recently ran across an article on ArsTechnica where five security experts were asked how they manage their complex passwords across a multitude of services. Four of these experts use password managers of some sort, though there is quite a variety of them. One actually remembers passwords, though he tries to use proximity tokens and one time passwords when possible.
There are various ports on different operating systems and different methods to keep your files in sync, if you choose to do so. Two others use competing products (1Password and KeePass), but one uses a text file in an encrypted virtual disk image that he keeps on a USB key. I'm not sure I like that, but with proper backups, it's not a bad solution.
There is a variety of advice, but overall there's one thing to keep in mind: security is serious business. All the more so as we use various services more and more to conduct business in our daily lives. Losing a password that you share across multiple services could severely compromise your life. Whatever method you choose, stick to it and be careful in choosing your passwords.
Join Red Gate for a free a seminar on July 26 (the day before SQL Saturday Sacramento). SQL Server MVP experts, Steve Jones and Grant Fritchey will present sessions featuring best practices for SQL Server database development and deployment, in addition to showing Red Gate tools in action. More »
SQL Saturday will be in Iowa City on July 27, 2013. This free day of SQL Server Training and Networking will also have pay-for pre-conference sessions presented by Bill Pearson, Louis Davidson and Tim Mitchell. More »
PowerShell provides comment-based help for functions and scripts with Get-Help, but when you want to document modues or generate a complete indexed API in HTML format, just as you can with Sandcastle for .NET or javadoc for Java, then stronger magic is required. Michael Sorens shows you how it is done, with source code. More »
Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks. Get your copy from Amazon today.
FORXML not retrieving complete xml
I am having the below XML
<marketDataSeries xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://pricesandcurves.ist.bp.com/xsd/CSL/IST/marketData/v1" xsi:schemaLocation="http://pricesandcurves.ist.bp.com/xsd/CSL/IST/marketData/v1 marketData.xsd" seriesID="urn:pc:FO.E.34639">
Autogrowth of database with it's file name
- I use below query to get auto-growth event occurred to databases in a sql server.
DECLARE @trcfilename VARCHAR(1000);
SELECT @trcfilename = path FROM...
How to create database from .mdf file only
I have installed SQL Server 2012 and downloaded sanple database from the below link, which has AdventureWorks2008R2_Data.mdf for download.
Index and Table Size
- Hello Everyone
Happy hump day to all.
I am working on gather some stats for each table in a database. I am...
check if index exists
i am creating script for non clustered ,
i need to see of particular index on column on particular table exists...
How to get the first date of my table?
- Hai friends,
i ve the table like below
create table student
insert into student values ('02-07-2013', 'A')
Prev and Next Row Without RowNumber
- Hello All,
Can anyone help me with this one.
here is the table sample.
CREATE TABLE [dbo].[Invoice_t](
[Cost_Center_code] [int] NOT NULL,
[Payment_code] [int] NOT NULL,
- I passed the 70-448 exam for the [url=http://www.microsoft.com/learning/en/us/exams/70-448.mspx]MCTS: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance [/url]certification this weekend....
Access Query ported to SQL
- Here is the "inner" part of a query in Access.
UPDATE [Vehicle Detail] SET [Vehicle Detail].ReturnDate = #4/29/2013#, [Vehicle Detail].ReturnSource = 'ReturnProcess'
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.