A simple trick for “Block Comment” syntax in SSMS
Make your comment blocks much more useful, in a surprising number of ways
Contracting for Work
The decision to work for yourself instead of full time for an organization can be a hard one.
Establishing a DevOps Organisation
DevOps might sound intimidating if your organisation has not yet begun on its DevOps journey. In this article, Rahul Varshneya explains some of the benefits and reviews the stages all DevOps organisations go through to achieve it.
Using the SQL Compare command line with Argfiles
Phil Factor demonstrates how using XML argfiles to pass parameters to SQL Compare cuts out a lot of the tedious scripting involved in modifying a database schema comparison and deployment process, as required for each target database.
Become a Technological Historian
This week Grant muses on how history can impact our decisions moving forward, and having a little empathy can be useful when re-examining the past.
Pattern Recognition via Principal Components Analysis
We'll look at using principal components analysis to help visualise your data and detect underlying structure or patterns.
Taking Notes – Paper or Keyboard?
Today we have a guest editorial from Andy Warren. When you need to take notes, how do you do it? Have you thought about it and experimented? Read on to see what Andy Warren does.
DevOps falling short?
Organizations are looking for help with their DevOps implementation, including Redgate tools, knowing where they want to go with their production and deployment but not sure where to start. Clear Measure have designed a 30-point DevOps Inspection & Report to provide you with the feedback and guidance you need to take your software development and deployment to another level. Request your inspection now.
Inventory SQL Server Agent Jobs for all Instances with PowerShell
In this tip we look at a PowerShell script you can use to gather information about all SQL Server Agent jobs on all SQL Server instances in your environment for quick reporting and analysis.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Riau Bisnis Center TLP/WA 08216977749
Jl. Riau No.36, Tampan, Kec. Payung Sekaki, Kota Pekanbaru, Riau 28292
BCA KCP Harapan Raya TLP/WA 08216977749
Jl. Imam Munandar No.312 C-D, Tengkerang Labuai, Kec. Bukit Raya, Kota Pekanbaru, Riau 28288
BCA KCU PEKANBARU TLP/WA 08216977749
Jl. Jend. Sudirman No.448, Tanah Datar, Kec. Pekanbaru Kota, Kota Pekanbaru, Riau 28115
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers