Spinach and Database Development- SQLSatExeter Keynote
Last weekend, we held our SQL Saturday event in Exeter. It was a brilliant event for many reasons but we...
2015-04-30
1,096 reads
SQL DBA With A Beard
Instances and Ports with PowerShell
Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I...
2015-04-22
1,330 reads
Checking SQL Server User Role Membership with PowerShell
SQLDBAwithTheBeard:
Please go and check the New SQL Bloggers posting here https://twitter.com/search?q=%23sqlnewblogger There are some brilliant new and older bloggers adding great value...
2015-04-24 (first published: 2015-04-14)
5,503 reads
PowerShelling SQL Saturday Sessions to the Guidebook app
Following on from my previous post about parsing XML where I used the information from Steve Jones blog post to...
2015-04-07
778 reads
Parsing XML Child Nodes and Converting to DateTime with PowerShell
As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to...
2015-03-31 (first published: 2015-03-21)
6,896 reads
Speaking at PowerShell Virtual Chapter and SQL Cardiff User Group this month
Just a quick post to say that I will be speaking at the PowerShell Virtual Chapter meeting this Thursday at 4pm...
2015-03-17
546 reads
Triggering a System Center Configuration Manager deployment task
A slightly different topic today.
Once you have built up knowledge, you become the person that people ask to solve things....
2015-03-02 (first published: 2015-02-18)
6,470 reads
Show AutoGrowth Events with Powershell to CSV
This week I was reading Pinal Daves post about Autogrowth Events
http://blog.sqlauthority.com/2015/02/03/sql-server-script-whenwho-did-auto-grow-for-the-database/
as it happened I had a requirement to make use...
2015-02-25 (first published: 2015-02-15)
6,257 reads
Uploading a Source Folder to Azure File Storage
Azure File Storage enables you to present an Azure Storage Account to your IaaS VMs as a share using SMB....
2015-02-09 (first published: 2015-02-01)
7,652 reads
Twas 2 Days Before Xmas or Thank you SQLFamily
Twas 2 days before Xmas & all through the office,
not a creature was stirring not even old Maurice.
With merriment going on...
2014-12-23
531 reads
Blogs
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common...
A New Word: Lackout
By Steve Jones
lackout – n. the sudden awareness that you’re finally over someone, noticing that the...
Delta Lake over Spark Connect
By Ed Elliott
All Spark Connect Posts I have just finished an update for the spark connect dotnet...
Forums
Shades and Reflecting on SQLBits and the Bright Future of Data
Comments posted to this topic are about the item Shades and Reflecting on SQLBits...
Merge techniques
In Azure SQL DB, i want to merge records from the staging table to...
SSRS error: The Value for the image 'Image1' has a constant value...
Full error message: SSRS error: The Value for the image 'Image1' has a constant...
Question of the Day
Adding Defaults
I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.
ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE() GO ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate GOWhat happens when I run these two batches? See possible answers