5 SQL Server scripts for novice DBAs

5 nifty SQL Server scripts including those to backup and restore databases

Comments

Post a Comment

Popular posts from this blog

The Mercurial Grok AI Assistant Understands & Speaks Indian Languages

Image
Grok , the AI model developed by Elon Musk's xAI, can understand when you type Indian languages like Hindi, Telugu, Odia or other Indian regional languages using English letters (like when you type 'namaste' instead of 'नमस्ते'), and it can respond by mixing English with those languages. Grok doesn't necessarily need the native script of these languages. It has natural language processing abilities that extend to multiple languages. This is great innovation because many people in India, especially in online communication, use transliteration. Grok can generate responses that combine English words and phrases with words and phrases from the regional language you used in your input. For example, if you ask a question using a mix of English and Telugu transliteration, Grok might respond with a sentence that includes both English and Telugu words. Check these Hindi, Telugu, Odiya samples - Grok, ab Hindi mein Grōk, ippuḍu telugulō Grok, Oḍiā re This way Grok is more...
Read more

HOW TO add a header or footer to a dynamically generated Word document

Image
There was a question recently on my CodeProject article "Dynamically generate a MS Word document using HTML & CSS" . The article describes how to generate a Word document programmatically without using any components, by exploiting the formatting features exposed through Office XML and CSS. The questioner wanted to know how to add a custom header and footer and show something like Page X of Y (total pages). Based on what I have tried so far, showing a header and footer using Office XML in MS Word is not as easy as it is in Excel . If you want to keep the code simple & don't need any great fireworks i.e. you will just settle for page numbers in the header or footer then it's a matter of adding a few lines to the original source code. The code can be viewed at this Github Gist Update (1-Sep-2010): To add a custom header & footer, check this new post To add a footer that shows Page number at the bottom right, here are the steps - 1) Add these classes...
Read more

HOW TO dynamically generate a Word document with custom header & footer

Image
Way back in 2004, a project I was working on required a web page to be exported as a Word document (.DOC). Without relying on any components, I utilized the Office XML & HTML technique to implement this feature. I posted my sample on CodeProject to seek feedback. Over the years, I've received some generous comments & feature requests. Many wanted to know how to add a header & footer to the dynamically generated Word document. With the help of the Microsoft Office HTML and XML Reference , I devised a hack to add a lacklustre header and/or footer . Some folks wanted to customize the contents of the header & footer but when they tried with my hack that offered limited functionality, the header/footer text showed up in the document body to their annoyance. This July, an ingenious developer posted a hack that can overcome this problem, in the Comments section of my CodeProject article. His practical workaround was to pack the duplicating header/footer text inside a t...
Read more