Try Some New Tools This Month
Today we have a guest editorial from Andy Warren. Today Andy suggests you try some new tools and see if you can increase your productivity.
Cumulative Aggregates in SQL Server Reporting Services
In this tip, we will see how to build a report which shows the cumulative sales amount for the current month, current quarter (QTD) and current year (YTD) in a single crosstab (tablix) report, which makes it easy to compare the data.
Healthy Work Habits
Today Steve Jones talks a little about the work environment for IT workers. We ought to pay attention and ensure we are taking care of ourselves.
Process Support Database Framework
Do you use or need a database process framework? Read on to see if this is something that might help you build better database software processes.
Using XML to pass lists as parameters in SQL Server
Every so often, the question comes up on forums of how to pass a list as a parameter to a SQL procedure or function. Phil Factor provides some examples using XML, and tests them against other popular methods.
No Cloud for Stack Exchange
The use of cloud computing isn't in the plans for the Stack Exchange network of sites? Steve Jones thinks they have a pretty cool reason not to use the cloud and he thinks you ought to have a similar view at work.
Controlling Growth of an msdb Database
I recently encountered a situation where the drive hosting Sharepoint Databases in a Staging environment ran out of space. I logged onto the server and found that the msdb database has itself occupied 38 GB of the total disk space. Msdb database generally contain maintenance information for the database such as backups, log shipping and so on.
Database Development Tasks Survey
We'd like to better understand the kinds of database related development tasks that you perform, so that we can ensure our tools are helping you to be more productive.
Back to Vegas
The DevConnections conference in the spring of 2012 is in Las Vegas, and Steve Jones is glad to be going.
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 Pondok Indah,Telp/Wa 0821.3111.159
Jl. Metro Pondok Indah No.60 & 61 UA, Pd. Pinang, Kec. Kebayoran Lama, Kota...
BCA KCP Jatinegara Barat. Tlp:(+62) 853-7373-7845
Jl. Jatinegara Bar. No.4 C 1, RT.2/RW.4, Wil, Kecamatan Jatinegara, Kota Jakarta Timur, Daerah...
BCA KCP Manhattan,Telp/Wa 0821.3111.159
The Manhattan Square, Mid. Tower, Lt. Ground Unit A & Lt. Mezzanine Unit A...
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