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,623 reads
Tuesday Morning SQL Break – May 26, 2015
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
Database Engine Tuning Advisor
I would love to see the Database Engine Tuning Advisor (DTA) pulled from the product. Completely. Heck, I feel bad that...
2015-05-26
833 reads
SQL Agent Job Wrapper Part 3 – Handing the Errors in the Wrapper Script
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
Default database
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
Microsoft Azure SQL Database – Dashboard
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
SQL Server 2016 features I’m interested in
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
SQL Server 2016 features I’m interested in
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
Row Numbers and Running Totals in SSIS
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
Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4
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
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates
This week I was at PASS Data Community Summit in Seattle, and I attended...
Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents
By James Serra
(This is the third post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCP Mahendradata Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Mahendradatta Selatan No. 99 AX, Padangsambian, Kec. Denpasar Bar., Kota Denpasar, Bali...
Alamat Telp BCA KCP Sesetan Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Raya Sesetan No.301, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80223
Question of the Day
Adding Bits I
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