SQL Server Management Objects: Lessons from the Wild
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
SqlCredit – Part 10: MAC Performance and Updating SqlCredit
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.
Cleaning Address Data with SSIS Using a Web Service
This article describes how to call a web service to clean up address data from within a data flow.
Quick Hits on the News for Nov 12, 2007
A few comment on the database news for the week ending 11/10/07
Sponsored Content
SQLServerCentral.com is always looking for ways that we can provide you with better, more useful content to help you learn about SQL Server. We've got a new idea and we're looking for feedback.
The Pace of Information
Is the rapid pace of information being fed to us a problem? Steve Jones has a few thoughts.
Index related DMVs and DMFs - sys.dm_db_index_usage_stats
Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats
Passing table valued parameters in SQL Server 2008
I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.
Working With SqlParameter in .NET
Interacting with SQL Server from .NET is a radical change from the old OLEDB/ODBC method. Raj Vasant brings us some easy ways to work with parameters passed in with the ADO SQLCommand.
Trustworthy Computing: Lessons Learned from Five Years of Building More Secure Software
This article discusses prioritizing code by age, using analysis tools and automation, looking at threats from multiple angles, and the importance of education
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers