Log File Space Issue Monitoring Using SQL Server DMV
As a continuation of “Database Monitoring using DMV” series, this blog will cover how quickly you can address the log...
2017-06-14 (first published: 2017-05-31)
5,800 reads
Blog Posts
Statistics Parser
In the last post we looked at using the STATISTICS IO and STATISTICS TIME commands to measure query performance.
If you’ve...
2017-06-14 (first published: 2017-05-31)
2,558 reads
Using ETL Staging Tables
Most traditional ETL processes perform their loads using three distinct and serial processes: extraction, followed by transformation, and finally a...
2017-06-14
960 reads
WinDbg and SQL Server Fun
I have a SQL Server that is constantly producing “dump” files (with a MDMP File type), these are named SQLDumpxxxx...
2017-06-14
628 reads
Behind the Scenes of an Online Presentation
Last week I presented my session "DBAs vs Developers: JSON in SQL Server 2016" at the online GroupBy Conference.
As I prepared for the event, I thought about all of...
2017-06-13
16 reads
Buzzword Bingo
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....
2017-06-13
980 reads
DevOPs and Databases — the one thing you may be doing wrong.
This blog post is part of T-SQL Tuesday Blog series — thanks to Grant Fritchey (t | b) – for hosting this month’s...
2017-06-13
645 reads
DevOps and Visual Studio
The hardest part about implementing DevOps is not the tools you choose, but the processes you use to make DevOps...
2017-06-13
1,140 reads
DevOps or DataOps Either Way It’s Coming to SQL Server
For T-SQL Tuesday #91 the topic is databases and devops. Grant Fritchey asks us: How do we approach DevOps as developers, DBAs, report writers, analysts and database developers? How...
2017-06-13
43 reads
DevOps or DataOps Either Way It’s Coming to SQL Server
For T-SQL Tuesday #91 the topic is databases and devops. Grant Fritchey asks us: How do we approach DevOps as developers, DBAs, report writers, analysts and database developers? How...
2017-06-13
14 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 Sambas Telp Cs 0817781222
WhatsApp:0817781222 Jl. Gusti Hamzah No.85, RT.02/RW.01, Pendawan, Kec. Sambas, Kabupaten Sambas, Kalimantan Barat 79465
Alamat BCA KCP Antasari Telp Cs 0817781222
WhatsApp:0817781222 Jl. P Antasari No.21, Tlk. Lerong Ulu, Kec. Sungai Kunjang, Kota Samarinda, Kalimantan...
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
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