New Web interface generator for multi-user SQL Server databases. Makes either complete DB interfaces with a single click, or web form fragments through model-based developer API. Sources available. Online showroom allows use and development; trial version available for download. (Announcement, not reviewed)
2003-05-20
1,154 reads
In this session we’ll rapidly discuss the MSCS clustering architecture and deploying the system into your environment. We’ll then jump into a demo where we actually cluster a Windows and SQL Server system in under 60 minutes. We’ll discuss the administration tools and best practices on clustering and walk you through completing a cluster and fixing problems along the way. After this session, you should have just enough information to build you own SQL Server that is highly available.
2003-05-13
893 reads
LockwoodTech has released a new version of SQLInserts with an entirely redesigned interface that supports client-side WHERE clauses, column level scripting, table level row maximums and much more.
2003-05-13
535 reads
Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.
2003-05-08
1,600 reads
This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.
2003-05-06
2,750 reads
As LockwoodTech Log Navigator Beta releases approaches we have released a bunch of new screen shots on product features. Log Navigator reads the MS SQL Server Transaction Log to allow you to passively audit data changes (inserts, updates and deletes) made to your database.
2003-05-05
619 reads
Fast Track to MDX gives readers all the necessary background information needed to write useful, powerful MDX expressions and introduces the most frequently used MDX functions and constructs. No prior knowledge is assumed and examples are used throughout the book to rapidly develop MDX skills to the point where a reader can solve real business problems. A CD containing examples from within the book, and a time-limited version of ProClarity, is included
2003-05-01
2,698 reads
SecureWave forwarded us this link to some info about their product - they claim to be the only product capable of protecting SQL Server from buffer overflow attacks. You can download a free eval from their site. We have not reviewed this product.
2003-04-29
1,001 reads
Another link from Steve Jones, this page has a great breakdown of the different types of RAM.
2003-04-24
808 reads
This white paper was written by Alain Dumas, founder of Sunopis. Looks interesting. Looks like they sell a tool that does ETL, replication, data cleaning, and more. We haven't reviewed the product, just thought it was something that might be of interest to our readers
2003-04-22
1,023 reads
By gbargsley
Recently, I was in a technical interview where the topic of running PowerShell at...
By alevyinroc
I don’t recall where this came up (probably in SQLSlack), but I had a...
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Hi, we put together an extract that runs every 15 minutes against what i...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Comments posted to this topic are about the item Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers