The ABCs of Database Creation
Creating SQL Server databases is easier than the internet may lead us to believe.
2017-08-11 (first published: 2015-10-29)
8,310 reads
Creating SQL Server databases is easier than the internet may lead us to believe.
2017-08-11 (first published: 2015-10-29)
8,310 reads
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.
2017-03-07
1,380 reads
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 1 of a 2-part article.
2017-03-06
1,334 reads
Not all SQL-generated scripts are created equal (or correctly) for alternative schema-owned objects.
2013-08-01
3,400 reads
What is ACID and why should we care? A look at the principal that drives all database and DB management software design: A.C.I.D.
2013-01-17
4,738 reads
A great list of SQL Server resources that you can use to help you improve your knowledge or ask questions.
2012-09-12
3,003 reads
How to change your "UPPER" or "lower" case strings to a mixed case
2010-10-18
6,076 reads
Learn three methods of creating random numbers that do not repeat in this article from Brandie Tarvin.
2010-08-12
9,305 reads
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
2008-03-05 (first published: 2007-03-13)
6,621 reads
How can you get started as a DBA? One of our authors takes a look back at her career and how it has evolved into a DBA role with SQL Server.
2007-11-26
5,674 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
How many table hints can I include in a query?
See possible answers