There was an article last week with a great title: The Mother of All Genealogy Databases, and so I had to take a look at it. It talks about some of the large databases on the Internet that are collection public records and linking them together to help people find out about their individual and family histories. The largest site so far, Ancestry.com, supposedly has 5 billion records.
Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean.
Lots of changes to the site, see how to work with some of them.
The third evolution in the history of SQLServerCentral.com is now out and available. Read all about the changes we've gone through.
That's what we were estimating the rewrite of this site would take. After all, to me it's a pretty simple site, a few content sections, some date specific stuff, scheduling, a few admin tools, not that much, right?
DDL Triggers are key improvement in SQL Server auditing, allowing tracking of events such as the creation of a new table, database or user.
Securing your SQL Server can be an arduous task, but very rewarding. This article covers 10 steps to properly protecting your data.
64-bit SQL Server is coming!! Are you ready for this new technology? Chances are most of you are like us in that you've never had a 64-bit machine around and you likely don't remember the transition from 16-bit to 32-bit. Do you even want to make the transition? Is it worth it? New author Robert Pearl brings us a first look at how the 64-bit version of SQL Server will differ from the 32-bit version.
SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server.
The next evoution of T-SQL, which will be released in SQL Server 2005, contains a number of enhancements designed to allow you to write more powerful queries while keeping the code structured in a way that makes development and understanding it easier. Coming ever so closer to the SQL-99 specification with Common Table Expressions, new author Srinivas Sampath brings us an introduction to this new way of writing complex queries.
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item This Week's AI Trust Problem...
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers