Creating an Azure SQL Database via PowerShell
This post is about using the brilliance of PowerShell to script the creation of databases in Azure.
Background:
Apart from the obvious question...
2017-05-11 (first published: 2017-04-30)
1,363 reads
The Hybrid DBA's Blog
Moving Azure resources between subscriptions – especially VSTS Team Services Account
For the past 6 months I’ve been paying for my own Azure subscription. My work has a plan but for...
2017-04-24
384 reads
Installing a Visual Studio Team Services private build agent hosted On-Premises
This blog post is about a situation where I use Visual Studio Team Services (VSTS) to build/deploy my DEMOs. Those...
2017-04-22
1,066 reads
Retrospective analysis of SQL Saturday South Island (#sqlsat614)
Now that SQL Saturday South Island (also known as #sqlsat614 on the Twitter) is done I thought it would be...
2017-04-22
248 reads
Resolution to “Connection Timeout Expired. [Pre-Login] initialization =18090; handshake=14281” error
This blog post is about a SQL Server connection issue that presents itself:
We were building an Availability Group (AG) at...
2017-04-20
429 reads
Can I tune the tempDB of an Azure based SQL Server database…
Yip. You can.
I was originally going to write this post about tuning tempDB in our Azure SQL database. Which would...
2017-04-02
386 reads
How to grow the exposure of a Data Platform based conference (SQL Saturday South Island)
SQL Saturday conferences are awesome.
That is the opening line of this blog post – because it’s true and understated.
If you’re reading...
2017-04-01
223 reads
Answer to “Could not locate file ‘xxx_Log’ for database ‘xxx’ in sys.database_files”
This blog post is a form of resolution to the issue of not being able to shrink a transaction log...
2017-03-24
226 reads
Having OCD in Azure…
Everyone gives OCD a hard time. When in fact it is something to embrace.
I am of course talking about Operational...
2017-03-22
251 reads
I like data – so Azure SQL is (initially) my focus..
My journey with Azure has been around what it can do for me – and the company I work for (Jade...
2017-03-22
212 reads
Blogs
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
T-SQL Tuesday #197 Invitation – An impactful session or two from a conference
By DataOnWheels
I am delighted to host this month’s T-SQL Tuesday invitation. If you are new...
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers