Analysis Services is slowly gaining in popularity and many of you might get drawn into setting up a server or developing a system based on this technology. Microsoft has released a performance guide to help you take performance into consideration from the beginning.
This article demonstrates that one way to optimize the data access portion of your app is to do the query once and cache the results. This is not advanced caching just something to get you started thinking about the possibilities.
Microsoft has released a new tool to analyzer your SQL Servers and see how they conform to their list of common best practices. Give it a try and let us know what you think.
In this short article that follows up on an earlier one that discussed dependency issues we have some code that will generate simple treeview type view of the relationships between procs. Mostly code, more so than usual, but we thought you might find the idea useful!
You point this application at a database and it generates a code unti that allows you to easily execute stored procedures and functions from Delphi. (Not Reviewed)
In this article by Robert Marda, he shows you how to use derived tables to solve some of SQL's problems.
At a recent seminar, Steve Jones heard a quote that really struck home. Especially in the computer business. Read on about a look at a DBAs take on listening to what you hear and being a little cautious in how you interpret it.
This article covers how to build the snapshot subscription without getting bogged down in too many low level details. You'll learn enough here to get started experimenting and get results. Depending on comments from you, we may ask Andy to move on to transactional replication or to dig deeper into snapshot options. Tell us what you think!
Do your developers really understand how to prevent injection attacks? Or scarier still, how many know what an injection attack is? Chris has some great examples of how sql injection works and how to prevent it.
New Author! Written as a rant, this article covers a couple basic issues that STILL tend to get overlooked in a lot of places. It's run to rant sometimes but we plan to maintain our focus and continue to keep these a small percentage of our content. Let us know what you think.
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Comments posted to this topic are about the item Meta AI by Facebook: A...
Comments posted to this topic are about the item The Monitor Server
Hi everyone, Our company receives data sets from over 100 clients on a monthly...
What does the monitor server do in log shipping?
See possible answers