Archive for the ‘SQL Server’ Category

Page 4 of 512345

Query Active Directory from SQL Server (again)

In: SQL Server

4 Nov 2008

Unlike my last post on the issue, instead of simply pointing to another blog for instructions on how to query Active Directory from SQL Server, I’ll provide some useful tips on getting things all working.

Testing Object Permissions with Impersonation

In: SQL Server

28 Oct 2008

Tutorial on how to test and verify account permissions with impersonation in SQL Server.

Converting between Gregorian and Julian Dates

In: SQL Server

23 Oct 2008

T-SQL functions for converting between Gregorian and Julian dates.

Transact-SQL Delighters (A few of my favorite things)

In: SQL Server

2 Oct 2008

I stumbled upon a few little gems that SQL Server 2008 includes that I hadn’t yet heard about. Although, very few are deploying SQL 2008 to production currently, these enhancements might make life programming in 2008 much easier.

Displaying row count for all tables

In: SQL Server

1 Oct 2008

T-SQL query to report the row count of all tables in a database without the heavy I/O cost of a table scan.


Page 4 of 512345

Categories

Archives

  • shiva ramani: good instruction. How to push data to MySQL from SQL 2005 [...]
  • Winkey: I've created a linked server for mysql successfully, and also can do Insert, Select. But when I try [...]
  • RaghuRam: Thanks a lot buddy it helped me to change the root password when I got the error trying to c [...]
  • Taylor Gerring: If you're on a 64-bit OS, did you run the 32-bit version of ODBC applet? Run: odbcad32 [...]
  • Taylor Gerring: If the issue is the guest sync'ing to the host, can't you just force time sync the host if you can't [...]


This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 United States.