With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.
Everybody knows how to call stored procedures from a .NET application. Right? But then, how often do you see stored procedures used to their full advantage in database applications? William Brewer goes through some of the basics, but uses PowerShell as the example .NET application, and avoids all mention of Northwind or AdventureWorks!
The importance of correct configuration. Which default configuration options to change. Common mistakes.
I hate to start a blog war, but maybe there's one going on. The recent PASS 2009 election concluded a...
With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.
With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.
With the election of the Board of Directors complete for 2009, Steve Jones takes a step back to examine what we might want from a professional organization. If you care about having an organization for SQL Server professionals, read this and let us know if you agree or disagree.
Businesses are always looking to collect data on their customers. However when they are fgiven this data, there is a level of trust from the consumer that is expected of the business. Guest editor John Magnabosco talks about the need for database professionals to take care that we are honoring this trust.
SQL Server Express has the same code base as the rest of the versions of SQL Server, but there are some differences in how to set it up and configure various tasks. MVP Brian Kelley shows us how to enable the Dedicated Administrator Connection.
Coming to Newport in the UK on Nov 19-21, be sure to register and attend if you are nearby. A few days of great SQL Server training.
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Telp Cso: (0821)8200174 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
Telp Cso: (0821)8200174 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
Telp Cso: (0821)8200174 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers