Creative Database Naming
Every now and again, we as DBAs need to get away from the daily grind of the hum drum tasks. We need to find a way to have a...
2020-01-02
586 reads
Powershell : Desire State Configuration -DSC
Powershell in 2012, Powershell 4.x onwards introduced Desire State Configuration(DSC) which help to build the standard configuration/ process /template for your system state and can be use or maintain...
2020-01-02
203 reads
POWERSHELL -SQL Assessment
June/July 2019 Microsoft – powershell is providing another great feature with SMO and SQL Server module as SQL Assessment. This is a great feature where Microsoft- SQL Server is...
2020-01-01
115 reads
Looking ahead to 2020
This week all I want to say is Happy New Year, and may 2020 be the start of a successful decade for you. Live, love, learn. Remember to take...
2020-01-01
22 reads
2019 in Review
What an incredible year it’s been. I kept thinking that I was busy, but I had no idea until I looked at the final numbers (I have a Power...
2020-01-01
125 reads
SQL Homework – January 2020 – Document, document, document
Happy New Year! It being New Year’s, at least by the Gregorian calendar, I thought we could make this month’s ... Continue reading
2020-01-01
31 reads
Cannot Open Backup Device
When running into error 1326, it makes plenty of sense to try to create a backup dump device (only as a testing exercise) as well as test the connectivity...
2020-01-01
28 reads
Cannot Open Backup Device
When running into error 1326, it makes plenty of sense to try to create a backup dump device (only as a testing exercise) as well as test the connectivity...
2020-01-01
359 reads
2019 Year in Review
As we open 2020 (and the house is still quiet on this New Year’s Morning), I thought I’d take a moment to reflect on the past year.
Blogging 2019 was...
2020-01-01
17 reads
Negative Port Numbers
Validating your server setup is an integral component of your duties as a SQL Server DBA. When performing those validations, it is possible to run into an intriguing difference...
2019-12-31
132 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Alamat BCA KCP Tendean Telp:0821-8200-203
Telp/Wa 62 8218200203 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...
Alamat Kantor BCA KCP Tendean Telp:0817.82.5533
Telp/Wa 62 817825533 Jl. Wolter Monginsidi No.129, RT.2/RW.2, Rw. Bar., Kec. Kby. Baru, Kota...
Alamat BCA KCP Gandaria City Telp:0821-8200-233
Telp/Wa 62 8218200233 Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar Muda,...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers