Stacked Bar Chart for Analysis Services Data
Put the stacked bar chart to work in your own business environment. BI Architect Bill Pearson continues his hands-on introduction to Reporting Services charts based upon Analysis Services data sources.
The SQLServerCentral Track at SQL Connections
I'm happy to announce that SQLServerCentral is sponsoring a track at this year's SQL Connections conference in Las Vegas, Nov 9-12, 2009. We're supplying the speakers, and picking the topics. If all goes well, we should be continuing this...
Backup Monitoring and Reporting
Ensuring that you can recover your server is critical. Chad Miller shows us how to accomplish daily backup monitoring and reporting.
Syncing Releases
Is the future for product releases and upgrades, to be synchronized with point releases? Steve Jones relishes the possibility.
Calling a Web Service from within SQL Server
One of the problems you might run into when building applications that consume web services is how you can use web services data within a SQL Server instance. Greg Larsen discusses how to do this within a stored procedure that only runs within the context of SQL Server.
Engine Separation of Duties for the Application Developer
Separation of duties is an important consideration for databases and database applications. By properly defining schemas and roles, you can create a distinction between users who can manipulate data from those that administer the database. This paper discusses the topics of which application developers should be aware and provides a heuristic example to guide you in achieving separation of duties.
Security Basics: Applying the Principle of Least Privilege Properly
Whenever I do a security presentation, I make sure to cover the Principle of Least Privilege. And when I do I boil it down to this very simple definition: Giving the rights to do the job. No more. No less.
SQLSaturday Events Coming Soon
Birmingham (May 20), Pensacola (June 6), and Portland (June 6) are upcoming SQLSaturday events. If you are in the area, please attend.
How to Become an Exceptional DBA
Brad McGehee provides a "career guide" for DBAs. It is intended both to help prospective DBAs find a "way in" to the profession, and to advise existing DBAs on how they can excel at their jobs, and so become Exceptional DBAs.
Providing Operational Analytics via Microsoft Analysis Services, Infor
This article will review the processes for providing Operational Analytics via Microsoft Analysis Services, Informatica and Qlikview
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 Graha Paramita. Tlp:08218168235
Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blok D-2, Daerah Khusus Ibukota Jakarta...
BCA KCP Delta Mas Tlpn/wa:085373737551
Ruko El Premio. 15 & 16, Kota Deltamas, Sukamahi, Kec. Cikarang Pusat, Kabupaten Bekasi,...
BCA KCP Pasar Puri Indah,Telpon/Wa 0821-8200-239
Blok A, Jl. Puri Indah Raya 20-22, Kembangan Sel., Kec. Kembangan, Kota Jakarta Barat,...
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