Jacksonville IT Pro Camp
Join system administrators and IT professionals for the Jacksonville IT Pro Camp on Saturday, June 16th, 2012.
IT Pro Camps are...
2012-06-03
1,255 reads
SQL Server Service Broker Explained
What is Service Broker?
Service Broker is a native SQL Server implementation of message queues.
What are message queues?
Message queues are a...
2012-06-03
243 reads
Max Server Memory
Sakthivel Chidambaram recently created a calculator which can find out the max server memory value based on the input.
http://blogs.msdn.com/b/sqlsakthi/archive/2012/05/19/cool-now-we-have-a-calculator-for-finding-out-a-max-server-memory-value.aspx
you can...
2012-06-02
5,221 reads
Investment for DBA Career
As IT professionals, we all will consider and take actions, at some point of time, to “invest” in our careers....
2012-06-02
1,076 reads
SQL Server 2008 Security Best Practices
If you are working as a DBA for a financial organisation where sensitive financial data is stored in your databases...
2012-06-01
13,350 reads
Are you ready?
I have talked about wanting a change. I thought I am prepared to embrace that change when it finally comes.
I...
2012-06-01
911 reads
June Question: Which DMV(s) do you most often use when managing your SQL Server instances, and why?
Dynamic Management Objects (DMVs and DMFs) are some of the most useful tools for the DBA. So this month’s question...
2012-06-01
1,062 reads
Setup windows firewall for SQL Server
On Windows 2008 R2, the windows firewall will turn on by default which causes connection issure for the remote client, here...
2012-06-01
5,432 reads
The Standing Desk – Week 1
I finally got my standing desk working last weekend and started on Tuesday (after Memorial Day) working at it on...
2012-06-01
1,123 reads
Ottawa In the Summer Time
I wrote a post earlier this week telling you all about my trip to Ottawa last week, during my trip...
2012-06-01
878 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