Daily Coping 27 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-27
13 reads
Blog Posts
I’ll be speaking at SQL Server Virtual Conference from C# Corner
I’ll be speaking at the SQL Server Virtual Conference from C# Corner, Friday Jan 29, 2021, with my friend Julie Koesmarno ( b | t ). I’ll be showing...
2021-01-27
25 reads
I’ll be speaking at SQL Server Virtual Conference from C# Corner
I’ll be speaking at the SQL Server Virtual Conference from C# Corner, Friday Jan 29, 2021, with my friend Julie Koesmarno ( b | t ). I’ll be showing...
2021-01-27
36 reads
Identifying SQL Server Performance Problems Part 1
Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database administrators to properly monitor and fix...
2021-01-27
607 reads
Identifying SQL Server Performance Problems Part 1
Every server, database, storage appliance and network encounter some sort of performance issues. It is a major part of our job as database administrators to properly monitor and fix...
2021-01-27
16 reads
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know...
2021-01-27 (first published: 2021-01-19)
1,182 reads
T-SQL Tuesday Retrospective #009: Beach Time
(If you’d like to read my other T-SQL Tuesday Retrospective posts, click here.) In August 2010, Jason Brimhall (blog | Twitter) invited us to discuss preparing for vacations: “Write...
2021-01-27
15 reads
What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: ... Continue reading
2021-01-27 (first published: 2021-01-19)
547 reads
Daily Coping 26 Jan 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-01-26
17 reads
Logical crossroads in Azure Data Factory (IF and Filter operations)
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach a crossroad with a large stone that had some directions written on it – turn...
2021-01-26 (first published: 2021-01-19)
222 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU RUNGKUT HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa Timur...
BCA KCU KEDIRI HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
BCA KCU GALAXY HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers