Migrating SQL Agent Jobs with Schedules using T-SQL
I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like....
2015-05-26
2,624 reads
I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like....
2015-05-26
2,624 reads
It’s Tuesday (Monday was a holiday for me this week) and time for this week’s weekly blog and twitter round-up for...
2015-05-26
553 reads
I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...
2015-05-26
834 reads
This is the 3rd installment in a small series of blog posts on how to create a PowerShell wrapper for...
2015-05-26
705 reads
What?
The default database is one of the options when creating a login in SQL Server. This is the initial database...
2015-05-26
1,103 reads
By David Postlethwaite
Once you have created your database you can now start to manage and configure it.
There are six...
2015-05-26
867 reads
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
505 reads
Microsoft announced this month what features/improvements will be in the next version of SQL Server, SQL Server 2016. You can...
2015-05-26
1,371 reads
During data load or transformation processes, capturing a distinct row number for incoming data can be beneficial for the ETL...
2015-05-26
3,335 reads
Hi friends, today we will learn how to get information about database mail profile using stored procedure sysmail_help_profile_sp. Sysmail_help_profile_sp stored...
2015-05-26
346 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, 'true')
GO
See possible answers