An Introduction to Database Models
Frank returns this week with a good non academic overview of the different types of database models and some of the features/problems that are native to each.
Microsoft SQL Server 2000 Analysis Services Performance Guide
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.
Optimize Your Applications
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.
SQL Server 2000 Best Practices Analyzer Beta
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.
Viewing the Hierarchy of Stored Procedures
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!
Delphi Code Generator
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)
Uses For Derived Tables
In this article by Robert Marda, he shows you how to use derived tables to solve some of SQL's problems.
A Grain of Salt
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.
Snapshot Replication for the Beginner - Part 2
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!
SQL Injection!
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.
Blogs
The pros and cons of self-service BI: What every industry leader should know
The post The pros and cons of self-service BI: What every industry leader should...
Off to the PASS Data Community Summit 2024
By Steve Jones
As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...
Implement a RAG Solution Using Azure SQL Database
By John
AI and ChatGPT are all the rage these days. Seems like around every corner...
Forums
How to change font size in Query window
I am running SQL Server 20.2. When I copy a query into the query...
is the ssrs auto refresh without its faults
Hi, i considered power bi with embedded for this. Not a big fan...
Random Execute SQL Task(s) keeps hanging when I try to run it in parallel
Hi everyone I am trying to implement parallelism in my SSIS package. There are...
Question of the Day
Cloud Sources for the Data Migration Assistant
Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)
See possible answers