Moving Files with Open Source Software, cURL and winSCP
Open Source, ON WINDOWS!
I’m still stunned in this day and age that people pay obscene amounts of money on tools...
2013-07-23
1,909 reads
SQL Server 2014: In-memory OLTP Engine, code-name: Hekaton
What looks to be the biggest and best new feature in SQL Server 2014 is called the “In-memory OLTP Engine”,...
2013-07-23
2,089 reads
A Vacation and Traveling to Sacramento
I’ve got a couple days off, starting today after my webinar on Preparing for When Disaster Strikes. I’ve got some...
2013-07-23
896 reads
I Learned Something From You
I learned something from you – that was something someone said to me at the end of a recent consulting engagement....
2013-07-23
763 reads
SQL Server Webcast: The Day After Tomorrow; Why YOU need to Baseline
Every day I consider myself extremely fortunate to be in a profession that I really enjoy, as there’s always something...
2013-07-23
801 reads
SQL Server Quickie #7 – TempDb Latch Contention
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Today I have...
2013-07-23
1,289 reads
Using Change Data Capture and CLR to Transfer Data to the Cloud
We were three: A DBA, a developer and a tester.
Our mission: To develop an ongoing process that will transfer one...
2013-07-23
1,548 reads
Are You the Primary Replica?
UPDATED -- Jul 3, 2015 -- To verify database exists, per comments by Konstantinos Katsoridis. Thanks for finding the bug!
In my recent adventures...
2013-07-23
1,678 reads
Query to Find "Update" Dependencies on a Table or View (SQL Server 2012)
The built-in dependency finder in SQL Server Management Studio does not provide the ability to distinguish between dependencies that are...
2013-07-23
2,871 reads
Security Questions: Granting Access with Jobs
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-07-22
606 reads
Blogs
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...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
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