The Sequel to SQL
Phil Factor tacks a few new buzzwords onto his CV and looks forward to joining the new wave of "digital innovators".
2019-08-10
655 reads
Phil Factor tacks a few new buzzwords onto his CV and looks forward to joining the new wave of "digital innovators".
2019-08-10
655 reads
There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.
2019-07-22
13,453 reads
With SQL Server we tend to build databases, when necessary, from one or more build scripts. If making changes to existing versions of the database, we then script the required changes. Usually, a synchronization tool will create a script that can be tweaked to work; although occasionally it will require something more complicated, as when […]
2019-06-29
320 reads
Just as you write a unit test before writing the code, so you must devise the means to monitor a database, to ensure its smooth operation, before creating the database.
2019-06-01
187 reads
Phil Factor feels that the database gets the short shrift in any outage - it's time to stop saying "the database has gone down" and time to start thinking about the resilience of the entire system.
2019-05-04
448 reads
In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.
2019-04-30 (first published: 2009-02-17)
619 reads
Phil Factor is excited for SQL Server 2019 and is keen to tell you why.
2019-04-06
679 reads
In this first level, we look at the overview of what metadata is contained in each database, gain some understanding of the different types of information, and examine a few basic examples.
2019-03-26 (first published: 2016-08-03)
5,850 reads
This level introduces keys, constraints, and relationships.
2019-03-26 (first published: 2016-10-19)
3,094 reads
In this second level of the Stairway, Phil looks at where we go to find information about objects, using triggers as the example.
2019-03-26 (first published: 2016-09-07)
2,920 reads
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
By Brian Kelley
If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...
Picture this, you’re happily backing up your database to a Azure blob storage until...
Comments posted to this topic are about the item An Incomplete Window Definition
Comments posted to this topic are about the item A Lack of Privacy in...
Comments posted to this topic are about the item Using the Import Extension in...