A Simple DR Solution
Tjay Belt brings us a quick and easy DR solution that might provide you some protection if you don't have a DR plan and want some lessons learned in this area.
Creating Views - SQL School Video
This video covers the basics of creating a view in SQL Server. Views allow you to treat a query as a table and simplify your query writing. This view covers the Query Designer in Management Studio.
You Are a Professional, So Speak Up
You are hired for your ideas so share them, it can only help your career.
Fast Database File Creation for Large Databases in SQL Server 2005
This article describes how to enable Instant File Initialization in SQL Server 2005
Social Profiling
This Friday Steve Jones talks about the social networking phenomenon and asks how it should affect your career?
Social Profiling
This Friday Steve Jones talks about the social networking phenomenon and asks how it should affect your career?
Social Profiling
This Friday Steve Jones talks about the social networking phenomenon and asks how it should affect your career?
Extending SSIS Part 1 - Creating a Custom Data Flow Transformation Component
In part one of this series from Actuality Business Intelligence, Ira Whiteside brings us a look at building your own SSIS transformation.
SQL Server 2008 SSMS Enhancements - Part I
SQL Server MVP Jacob Sebastian starts a new series looking at the changes in SQL Server 2008 to the management tools.
Stored Procedures Reconsidered
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
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