A Cloudy Week - Database Weekly (Mar 2, 2009)
There has been a lot of news about cloud computing this past week, including an announcement about SQL Server.
2009-02-28
1,009 reads
Articles
Correlated Joins Using "Apply"
Discusses the use of the newly introduced APPLY Statement in SQL Server 2005
2009-02-27 (first published: 2008-06-16)
24,972 reads
A first look at Visual Studio 2008 Database Edition
Learn about Microsoft Visual Studio Team System 2008 for database professionals, a useful tool for database development with Microsoft SQL Server.
2009-02-27
4,544 reads
Creating and Using Databases in Android
Every application uses data, and Android applications are no exception. Android uses the open-source, stand-alone SQL database, SQLite. Learn how to create and manipulate a SQLite database for your Android app.
2009-02-27
1,630 reads
How do I ... Determine Database Growth If I Am Not Tracking It? -- Error Logs Part III
How do I ... Determine Database Growth If I Am Not Tracking It? If your database has grown considerably and you're not sure when or why it happened, you'll be hard pressed to figure out the answer unless you're tracking changes in database size.
2009-02-27
4,388 reads
Running A Basic DMX Query - SQL School Video
This SQL School video introduces us to the data mining queries that you can run from BIDS in an Analysis Services project.
2009-02-26
4,764 reads
How to move a SQL Server database within the same instance without losing settings
I want to move my database on my SQL Server 2005 system to a new drive, but I have database options, like cross-database ownership chaining, that I don't want to lose or have to remember to re-apply. How can I do this?
2009-02-26
2,969 reads
Service Broker Transactional Support in SQL Server 2005 Express Edition
This article provides an overview and presents an example illustrating the role of transactions in processing Service Broker dialogs usage.
2009-02-26
1,389 reads
You Must Trust Someone
After some recent talks with security folks and auditors, one of the things I have had a hard time getting across is that you must trust those folks responsible for account and server management when it comes to securing your data. Yes, you can put in...
2009-02-26
2,549 reads
XML Workshop XXIII - A TSQL ATOM Library
MVP Jacob Sebastian has written a great series on working with XML in SQL Server and we have the latest installment today. This time he presents a library of functions that can produce an RSS ATOM compliant feed of data.
2009-02-25
3,950 reads
Blogs
A New Word: Ecstatic Shock
By Steve Jones
ecstatic shock – n. a surge of energy upon catching a glimpse from someone...
The CDO’s Playbook for AI Driven Decision Making
By Chris Yates
The New Arena of Leadership The role of the Chief Data Officer is no...
sp_snapshot – The easy way to take database snapshots of one or more databases – V3.0
Presenting you with an updated version of our sp_snapshot procedure, allowing you to easily...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Email..dmtworld2@gmail.com..Buy MDMA Ecstasy Pills, Black Tar Heroin, Pink Cocai
Email..dmtworld2@gmail.com Telegram..@jemsscott237 Vaping DMT makes it considerably more advantageous when contrasted with really illuminating...
Question of the Day
Who am I?
If I want to track which login called a stored procedure and use the value in an audit, what function can I use to replace the xxx below?
create procedure AddNewCustomer
@customername varchar(200)
AS
BEGIN
DECLARE @added VARCHAR(100)
SELECT @added = xxx
IF @customername IS NOT NULL
INSERT dbo.Customer
(
CustomerName,
AddedBy
)
VALUES
(@customername, @added)
END See possible answers