2013-02-06 (first published: 2012-12-27)
1,851 reads
Scripts
Create and Populate a Date Dimension Table
Creates and populates a date-dimension table suitable for OLTP or data warehouse purposes.
2013-02-04
3,281 reads
Change database compatability level of all databases
Changes the database compatibility level of all databases to the given level.
2013-01-31 (first published: 2013-01-07)
938 reads
List Database Users and their Corresponding Roles
Database Users and their Corresponding Roles and type login.
2013-01-28 (first published: 2013-01-16)
2,118 reads
Grouped Failover, a 2008R2 version of Availability Groups
One of the new cool features in SQL 2012 is the SQL Server Availability groups. In other words being able to failover a group of databases which are logically connected. i.e. SharePoint databases. Well, it is also possible to do that in SQL 2008 (R2). It’s called a Grouped Failover.
2013-01-24 (first published: 2013-01-16)
574 reads
2013-01-18 (first published: 2012-06-21)
1,378 reads
Query Active Directory to Display Login Information
Query Active Directory to get information on user logins.
2013-01-18 (first published: 2011-05-16)
3,865 reads
GetDateInString
This function will return a value of date if found within a string, the date format in the string will vary. If no date is found a null value is returned
2013-01-17 (first published: 2012-12-18)
1,274 reads
Database details for Daily checks
Get database status,file details,free space
in sql 2005 and 2008 sql versions
2013-01-16 (first published: 2012-12-07)
2,526 reads
2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
2013-01-11 (first published: 2008-11-07)
2,735 reads
Blogs
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
Forums
ALAMAT KONTAK BCA KCP Pecatu Telp:08218154393
WA:08218154393 nomor 275 Blok 4, Jl. Raya Uluwatu dan 5 No.99, Ungasan, Kec. Kuta...
ALAMAT KONTAK BCA KCP Ubud Telp:08218154393
WA:08218154393 Jl. Raya Ubud No.10, Petulu, Kecamatan Ubud, Kabupaten Gianyar, Bali 80571
ALAMAT KONTAK BCA KCP Benoa Telp:08218154393
WA:08218154393 Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers