Jobs in PoSh to Create a Load
I saw this from Argenis Fernandez, and thought it was wonderful.
1..128 | % { start-job -name ‘job name’ -scriptblock { & sqlcmd -S instanceName -U...
2018-05-23
824 reads
Virtual Log Files: 200 or 1000?
Last week I had the privilege of reviewing possibly the best SQL Server production environment I’ve seen in Canada. During...
2018-05-23
491 reads
The public role
A common misunderstanding is that the CONNECT permission lets you do more than just connect to a database. It doesn’t....
2018-05-23
486 reads
dbachecks – Save the results to a database for historical reporting
I gave a presentation at SQL Day in Poland last week on dbachecks and one of the questions I got...
2018-05-31 (first published: 2018-05-23)
3,075 reads
Deploying Azure Container Instances
In a previous post I went through how to Push an image to the Azure Container Registry
Now let’s look at...
2018-06-04 (first published: 2018-05-23)
2,083 reads
How to pass data between procedures using temp tables.
In this post I will show how in some cases we can split a long procedure to a small and...
2018-05-23
1,802 reads
PoshSSDTBuildDeploy Updated - Now With Pester Tests
Hello!
Some weeks ago I got the tests working on the CI build for PoshSSDTBuildDeploy. The tests were a bit of a mish mash, however they sort of did the...
2018-05-23
40 reads
Backup Linux/windows SQL Server databases using PowerShell and Windows task scheduler
This article is an in-depth guide on how PowerShell can be used to maintain and manage SQL backup on Linux...
2018-05-31 (first published: 2018-05-22)
2,101 reads
SQL Saturday – Dallas – May 2018
I was able to present at SQL Saturday Dallas this year. Thanks to those of you who were able to...
2018-05-22
213 reads
SQL Saturday Iowa City Precon June 22
I’m extremely proud to announce that I have been selected to present an all-new preconference training session on Friday, June...
2018-05-22
291 reads
Blogs
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers