AG without WSFC SQL 2017 and more…
Starting Sql Server 2017 Microsoft can allow you to enable the configuration manager for “Always ON” feature for standalone system without WSFC and linux without Pacemaker . it has...
2019-11-11
51 reads
Last Week Reading (2019-11-10)
Hello all! An extraordinary week has just passed. Two big conferences took place in the USA, PASS Summit and Ignite, where Microsoft announced plenty of new products or updates....
2019-11-10
17 reads
Wrangling data flows in Azure Data Factory: Calculating distance between two Geo-points
(2019-Nov-10) Microsoft has recently announced a public preview of the Wrangling data flows in Azure Data Factory (ADF). What used to be called Power Query in Excel, Query Editor in Power...
2019-11-19 (first published: 2019-11-10)
2,071 reads
MAXDOP and Tempdb – SQL 2016
Starting SQL Server 2016 Max Degree of Parallellism (Max DOP) Macrosoft has made hanges on this and now we can set it at database level. This helps for replication...
2019-11-09
194 reads
Omaha Azure User Group Presentation Nov 18
I’m happy to announce that I’ll be presenting an in-person session for Omaha’s Azure Users Group on Monday, November 18 at 3:00pm, entitled “SQL Server in the Microsoft Cloud“....
2019-11-09
25 reads
Rounding Out PASS Summit 2019
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things...
2019-11-15 (first published: 2019-11-08)
462 reads
Focusing on Business Value
This was a fun talk with David Atkinson at Redgate. We talk satellites, finance, and more. Including some early history of the company. We are talking about how to...
2019-11-14 (first published: 2019-11-08)
240 reads
What SQL Server Agent Alerts Do I have setup?
I am in a situation where I have to incorporate SQL Server Agent alerts in my monitoring and alerting strategy.I needed a query (DMV) to get details on what...
2019-11-18 (first published: 2019-11-07)
678 reads
Finding out the most cached database in the buffer cache - The DMV Way
While there are many ways and criteria to find out what database is the most used, under optimized, trouble maker etc....., here is one more to find out the...
2019-11-07
202 reads
Pass Summit 2019 Keynote Day 2
I’m blogging they Keynote! One of my bucket list things has always to live blog a keynote at Pass Summit ... Continue reading
2019-11-07
106 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
Alamat BCA KCP Sopo Del Telp:0821°7555°651
Telp/Wa 62 8217555651 Gedung Sopo Del Office Tower A Lantai GF-15, Jl. Mega Kuningan...
Alamat BCA KCP South Quarter Telp:0821-8200-203
Telp/Wa 62 8218200203 South Quarter Tower, Jl. R.A. Kartini No.Kav. 8 B, Ground Floor...
Alamat BCA KCP Graha Paramita Telp:08218200233
Telp/Wa 62 8218200233 Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blk D-2, RT.7/RW.4,...
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