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
Brian spends a lot of time in our forums helping out. Based on a recent question from a reader he put together some tips he used when he was preparing for the MCSE exams. Interesting reading!
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.
Greg returns with an article based on some practical experience using QA templates to save time and work. Good examples, good work through, good idea!
Another link from Steve Jones, this page has a great breakdown of the different types of RAM.
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
Do you use @@version? sp_server_info? What's the difference? Read on to see what each of these methods returns and which one you should be using.
A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
TechEd will have 350 sessions designed to suit the needs of developers, architects, IT professionals, database, network and system administrators, messaging and security specialists. Andy is going, if you're planning to attend post a comment or send him email (awarren@sqlservercentral.com)!
Joseph recently had to upgrade a server from 4g to 8g of memory. Read how he did it and learn about some interesting aspects of AWE. For example, if you have 6.5g configured for use by SQL, how will task manager show used by sqlserver.exe?
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
I've written some documentation on using different Markdown types of files on GitHub. It's...
Comments posted to this topic are about the item Not Just an Upgrade
Comments posted to this topic are about the item Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers