Get Backup History for All Databases in Server
Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...
2016-10-31
489 reads
Why Halloween slowed your queries
Let me start by saying that this isn’t your typical post about the Halloween problem. This is intended to describe...
2016-10-31
1,004 reads
Get Backup History for All Databases in Server
Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...
2016-10-31
958 reads
Watch my PASS Summit Session on PASS TV
I’m just returning from an amazing week at PASS Summit where I meet many of you while working our Pragmatic...
2016-11-08 (first published: 2016-10-31)
1,481 reads
t-sql random string generator
Note: originally published in our old blog on December 2008.
CodeProject
This is a simple stored procedure that you can use to generate a random string. You can use it...
2016-10-31
22 reads
t-sql random string generator
Note: originally published in our old blog on December 2008.
CodeProjectThis is a simple stored procedure that you can use...
2016-10-31
5,314 reads
A Recap of PASS Summit 2016
Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I...
2016-10-31
902 reads
The Halloween Problem
DBA: Help me! Help me! It’s Halloween! I have a problem! Oh won’t you please help me!
Ok, so that’s really...
2016-11-07 (first published: 2016-10-31)
2,742 reads
Master Data Services – Database Error has Occured when Publishing Business Rule
I was preparing a demo for a session about the new features of Master Data Services in SQL Server 2016....
2016-11-04 (first published: 2016-10-31)
3,247 reads
PASSion Award and what it means to me
2016 is going to be a special year in my life. There was an article on Oscar awards a while...
2016-11-04 (first published: 2016-10-31)
1,777 reads
Blogs
A New Word: Semaphorism
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
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...
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCP Tanggul Hub/Wa. 0817-819-444
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Layanan BCA KCP Jajag Hub/Wa. 0817-819-444
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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