Copy Only Backup for SQL 2005 and SQL 2008
Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?
Execute SQL and Bulk Insert Tasks in SSIS
Learn how the Execute SQL and Bulk Insert tasks can be combined to create a database and insert data into the database.
Tips on Getting Hired – Part 4
Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake of thinking it will always be easy. Equally, finding a good job is harder still. Some more tips for you to consider: Leverage your recruiter. They know..
Disaster Recovery - An Afterthought?
Disaster Recovery is always ranked by DBAs and managers as one of the most important things to have set up. Yet many people working with databases don't spend time on this. Steve Jones has a few comments from the news this week.
SCOME - Part 4: Using Visual Studio To Develop The Report
Part 4 of this series from Drew Salem shows how you build a report in Visual Studio.
What's Your Ideal DBA Job?
Brad engages in a little Summer daydreaming, and wonders what the Ideal DBA job would look like...
Page compression in SQL Server 2008
Page compression is a new feature available in Enterprise and Developer editions of SQL Server 2008. In this article, MAK discusses how to enable PAGE data compression on a table and index.
When the next object-persistence boat comes in.
Phil enjoys an old Microsoft Training manual and wonders why it is no longer possible to encompass the whole of SQL in a 400 page book any more..
Who's been logging into my SQL Server?
In a recent blog post, see the steps Denny Cherry thinks are vital to monitoring both successful and unsuccessful outside user logins to your SQL Server.
Making Demands
Imagine you are invited to speak somewhere and you have a bit of power. Have some fun with this Friday's poll and let us know what you'd demand.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers