DR drill - Part 2: Log Shipping
Welcome back to DR drill series!
In the last post (here), we have highlighted a number of ways to setup disaster...
2015-09-22
1,510 reads
Blog Posts
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates In this post we’re going to cover configuring a connection string in .NET applications for encrypting connections to SQL Server using certificates....
2015-09-22
24 reads
Encrypting Connections To SQL Server Using Certificates
Encrypting Connections To SQL Server Using Certificates
In this post we’re going to cover configuring a connection string in .NET applications...
2015-09-22
7,300 reads
Finding Next Business Day in T-SQL
Let’s say you have a table that records transactions along with the date of when the transaction took place. Wait,...
2015-09-22
5,242 reads
Finding the worst running query in a stored procedure
The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something...
2015-09-22 (first published: 2015-09-10)
4,896 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
548 reads
Heading To PASS Summit 2015 – Now What?
You’ve heard about it for some time now, and you finally got the gumption to ask your boss if the...
2015-09-22
332 reads
Improving Networking at PASS Events–Part 1
This week I’m spending some drive time thinking about how we might improve networking at SQLSaturday and that led to...
2015-09-22 (first published: 2015-09-10)
1,168 reads
Most Read: My Top 5 SQL Server Articles and Blogs
There has been some really useful blogs and articles posted over the last week or so, this is my top...
2015-09-22
536 reads
Populating My DBA Database for Power Bi with PowerShell – Databases
Following my post about using Power Bi with my DBA Database I have been asked if I would share the...
2015-09-22
873 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