CPU Scheduling Basics – Windows and SQL Server
In this post we’re going to introduce the basics of CPU scheduling.
In a computer system, only one thing can happen...
2016-05-26
1,397 reads
SQL Server – Rollback transaction completely in case of error
Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback...
2016-05-26
670 reads
The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
“The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)” error may occurs when executing PowerShell scripts using WMI query.
There can...
2016-05-25
2,965 reads
Azure Storage pricing
Azure storage is a great, inexpensive solution for storing your data in the cloud. There are many types of Azure...
2016-05-25
957 reads
A Basic Recursive CTE and a Money Lesson
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-05-25
802 reads
Connecting to Azure SQL Database
Recently I created my first Azure SQL Database. But now I need to connect to it.
You can connect using...
2016-05-25
549 reads
A Moment For Reflection…
While this is a personal blog, I try to keep it focused on either technical topics or personal development and...
2016-05-25
497 reads
Changing Your PASS Credentials
I got an email today from PASS, noting that credentials were changing from username to email. That’s fine. I don’t...
2016-05-24
553 reads
Some Pester Tests for SQL Defaults
When I was at PowerShell Conference EU in Hannover last month (The videos are available now – click here and the...
2016-05-24
615 reads
XML-> JSON document Example
Convert the XML document to JSON document example
<person>
<name>John</name>
<age>25</age>
<address>
<city>New York</city>
<postalCode>10021</postalCode>
</address>
<phones>
<phone type="home">212-555-1234</phone>
<phone type="mobile">646-555-1234</phone>
...
2016-05-24
481 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Preserving Data
Comments posted to this topic are about the item Preserving Data
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers