Check Windows Services Status with T-SQL
In this article we look at creating a SQL Server stored procedure that displays a list of all Windows services based on running or stopped state.
Learn about Version Control with Redgate University
Are you new to Version Control and not sure where to start? Visit the Redgate University and check out Steve Jones' Introduction to Version Control course. In just 20 minutes Steve will give you a rundown of what version control is and what the benefits are.
Get involved in the 2021 State of Database DevOps survey
We’re inviting you to take part in the 2021 State of Database DevOps survey! Now in its 5th year, the leading research on Database DevOps will also explore how DevOps strategies have contributed to the resilience of the database during the pandemic. Complete the survey to get exclusive access to the final report and the chance to win a $500 Amazon gift card. Take the survey here.
Visualizing Azure Resource Metrics Data in Power BI
Learn the five steps to perform Azure resource reporting with Power BI in order to embed the reports in dashboards for stakeholders.
The Wide Impact of PASS
An organization, or an event, is more than just the name and structure. It's mostly the people.
Generate QR Code® barcodes in an SSRS report with the QRCoder library
QRCoder is an open source implementation of standards specification ISO/IEC 18004, which defines the requirements for two-dimensional QR Code symbols. It is a more complete implementation of the standard than the open source QRCode4CS library that was used in a previous article.
Managing Cross-Database Object References
Phil Factor explains cross database and cross-server references, how to find them in your code, and when it's better to avoid hard-coding these references and use synonyms instead.
SQL Server
I am new to SQL Server and I have heard the term used in a number of different capacities and in different contexts. So what exactly is it? What are the common components? How does it work? How do people use it? I am brand new to the technology, where do I get started?
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Kapuk Kamal Telpon/WA:08213111185
BCA KCP Kapuk Kamal Telpon/WA:08213111185 No. 1A, Jl. Kapuk Kamal Raya Blok DEF, Kamal...
BCA KCP Kosambi Telpon/WA:08213111185
BCA KCP Kosambi Telpon/WA:08213111185 Komp. Perum Kosambi Baru Jl. Nusa Indah Tengah Blok A,...
BCA KCP Taman Palem Lestari Telpon/WA:08213111185
BCA KCP Taman Palem Lestari Telpon/WA:08213111185 Komp. Perum Jl. Taman Palem Lestari No.C5 No....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers