SQL security scripting - TSQL
SQL DBA often needs to script SQL Logins,Server roles,database users and Roles. Although its easy to script login,roles and users with...
2012-08-02
1,294 reads
SQL Server 2012 – Enter the EOMONTH Function
In this blog post, I will be sharing a new date feature in SQL Server 2012 called the EOMONTH (End...
2012-08-02
1,786 reads
SQL database Incremental Shrink TSQL
When we shrink a SQL database through GUI we usually find the database never releases all the free space, It...
2012-08-02
12,875 reads
Performing Unattended Installs of SQL Server 2012
In my post here, I’ve discussed the procedure to perform attended installation of SQL Server 2012 on a Windows Server...
2012-08-02
9,918 reads
SQLSailor is exploring(Part4) – Basic DML,DDL operations with SQL Databases on Windows Azure
In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.
This post is in continuation with my...
2012-08-01
820 reads
SQL Server 2008 R2 Service Pack 2 Cumulative Update 1
Microsoft has released SQL Server 2008 R2 Service Pack 2 Cumulative Update 1, which is Build 10.50.4260.0. This CU has...
2012-08-01
2,145 reads
Forty Five Minutes
Excellent: Dilbert on data analysts
The best part is the last quote: I like how you punctuate your ignorance with certainty.
Filed...
2012-08-01
1,045 reads
SQL Server : Implementation of Table Valued Parameter (TVP)
Some time there will be situation in application , where a
grid is populated with data and user has option to edit...
2012-08-09 (first published: 2012-08-01)
6,360 reads
Prevent wiping out of SSAS partitions
There have been a few times when I have created SSAS partitions outside of BIDS using script code in an...
2012-08-01
1,033 reads
Set Up SQL Server Mirroring T-SQL Script
T-SQL Script to create a SQL Mirroring:-
The first thing you need to do when setting up Database Mirroring is perform...
2012-08-01
20,355 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 KCU YOGYAKARTA Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Jend. Sudirman No.49-51, Terban, Kec. Gondokusuman, Kota Yogyakarta, Daerah Istimewa Yogyakarta...
Layanan BCA KCU PURWODADI Telp:0821°8200°233
Telp/Wa 628218200233 Jl. MT. Haryono No.2, Jengglong Timur, Purwodadi, Kec. Purwodadi, Kabupaten Grobogan, Jawa...
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