SQLSat Pcola 2017 Security Principals and Permissions
Great attendance and awesome questions from my afternoon session on "SQL Security Principals and Permissions". As promised, both the demo...
2017-06-05
280 reads
VSTS– Hosted Agent is the Default for Releases
In keeping with the idea I don’t want this to get out of date, this is VSTS as of Jun...
2017-06-05
617 reads
Database Fundamentals #1: Install SQL Server
To get started with SQL Server, you need to install it. However, I’m not going to teach you how to...
2017-06-05
542 reads
Backup to NUL
Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In...
2017-06-05
7,541 reads
Endpoint Owners – Back to Basics
"What the heck is an endpoint?" Well, that is a good question. An endpoint in the simplest form is a connection or point of entry into SQL server.
Related Posts:
Changing...
2017-06-05
49 reads
Endpoint Owners – Back to Basics
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2017-06-05
1,635 reads
SQL Server – Service Terminated
I had a messy (another one) day, last thing I wanted was a “broken” SQL Server instance where I was...
2017-06-05
417 reads
Monday Coffee – Lab Environments
Having a lab environment is an absolute must for any IT professional. You need somewhere that you can test out...
2017-06-05
286 reads
SQL Server Application Roles
If you’re using Windows Authentication then you probably have a database user for each user of your application or at...
2017-06-05
210 reads
SQLSaturday Orlando 2017 Goes Live
Today we’re starting on our 11th SQLSaturday here in Orlando. Normally we rotate the leadership between oPASS and MagicPASS, but...
2017-06-05
516 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