SqlSiteMapProvider reads site maps from SQL Server databases. And it takes advantage of the ASP.NET 2.0 provider architecture to integrate seamlessly with the site navigation subsystem. Just create the site map database and register SqlSiteMapProvider as the default provider, and then, like magic, everything else just works.
What is the cost of DRI and is it something that you should implement? SQL Server expert David Poole takes a look at the impact of adding DRI to a CMS system and provides some real world results on which you can base your decision.
In Part Two of his series, database administration expert Baya Pavliashvili explores the challenges involved in building and maintaining a warehousing solution using a simple database warehouse.
A bit of a break from the SQL Server side with this great new .NET class developed by new author Jereme Guenther. He prints a page character by character to handle control of formatting. Take a look and see if this solves any of your .NET printing problems.
In the first of a two-part series, Baya Pavliashvili, database administration expert, offers solutions to your business problem using a data warehouse.
T-SQL has some well known limitations when working with parameters for a stored procedure, not the least of which is a variable number of parameters. While there are some solutions, they can be cumbersome to work with. Sloan Holliday brings us a creative solution using XML that can solve many issues.
You can improve your SQL performance by using indexes. But you have to choose the proper indexes and make sure the ones you do choose fit into your business situation. In this indexing guide, you will find answers to common indexing questions, indexing dos and don'ts, and tricks for working with the Index Tuning Wizard to improve overall system performance for SQL Server 2000 servers. This is particularly useful for servers that need a boost before they are upgraded to SQL Server 2005.
Have you ever wanted to create your own utility procedures in SQL Server? Maybe your own information schema view? SQL Server export David Poole brings us an article dicussing these very topcis and offers advice on how to proceed.
A SQL Server DBA often needs to perform ad hoc operations on data in their databases. The tasks can typically be handled with simple T-SQL statements, but other times a more complex operation is called for – and having to manually enter all the T-SQL code necessary for such an operation is not appealing! It can be difficult to perfect the syntax, and tedious to list column names once, twice or even three times. Fortunately, useful template code can be easily generated instead of being entered by hand.
A defense-in-depth strategy, with overlapping layers of security, is the best way to counter these threats, and the least-privileged user account (LUA) approach is an important part of that defensive strategy. The LUA approach ensures that users follow the principle of least privilege and always log on with limited user accounts. This strategy also aims to limit the use of administrative credentials to administrators, and then only for administrative tasks.
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers