The Institute for Backup Trauma
Today we have an editorial reprinted from April 27, 2005. Steve Jones is on vacation, so we are reprinting this look at backup strategies and media.
The Twelve Days of SQL
As we approach the holidays, Steve Jones talks about the latest blog theme, and how nice it is to see these types of things from the community.
Can You Dig It? – Missing Indexes
She can dig it!
D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...
Get script for every action in SQL Server Management Studio
I am always conscious to keep a record of all operations performed on my database servers. Operations through T-SQL in an SSMS query pane can easily be saved in query files. For table modifications through SSMS designer I have predefined setting to generate T-SQL scripts. However there are numerous database and server level tasks that I use the SSMS GUI and I would like to have a script of these changes for later reference. Examples of such actions through the SSMS GUI are backup/restore, changing compatibility level of a database, manipulating permissions, dealing with database or log files or creating/manipulating any login/user. I am looking for any way to generate T-SQL code for such actions, so that it may be kept for later reference
SQL Server 2005 SP4 Has Been Released
Microsoft completed SQL Server 2005 Service Pack 4 recently and made it available at the end of last week.
A faster way to prepare dimensional databases
When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?
Under Appreciated Features
This Friday we have a guest editorial from Andy Warren that asks about those features in SQL Serve that you find very useful, but perhaps aren't as well known.
New DMF for SQL Server 2008 sys.dm_fts_parser to parse a string
Many times we want to split a string into an array and get a list of each word separately. The sys.dm_fts_parser function will help us in these cases. More over, this function will also differentiate the noise words and exact match words. The sys.dm_fts_parser can be also very powerful for debugging purposes. It can help you check how the word breaker and stemmer works for a given input for Full Text Search.
Hyper-V Guests
To what extent should a hypervisor company support other software? Will this have implications for cloud computing, or services used in software? Steve Jones comments.
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
identity increments by 10,000 when it was supposed to be 1
hi a peer of mine who ive never known to be wrong says a...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers