A Private Database
Having separate databases for each client? It's a common problem and Steve Jones wonders if this might be a feature coming in SQL Server at some point.
A Private Database
Having separate databases for each client? It's a common problem and Steve Jones wonders if this might be a feature coming in SQL Server at some point.
Oracle and SQL Server Data Interoperability Issues - Part 1
As much as we're SQL Server folks here, sometimes we do need to connect to other data stores. Hai shares some of his experiences doing so. Might come in handy someday.
An Introduction to SQL Server Service Broker
This paper introduces Service Broker, a new feature in Microsoft SQL Server 2005. With Service Broker, internal or external processes can send and receive guaranteed, asynchronous messaging by using extensions to Transact-SQL.
KPIs in Analysis Services
KPIs or Key Performance Indicators are one of the most important entities in driving business decisions. It can be defined as a (quantifiable) measurement used to define and measure an organization's progress in achieving business goals. KPIs for an organization are decided upon by giving careful thought to how each goal and the progress towards these goals should be measured.
A Closer Look At SQL Server Compact Edition
In a followup to his article on SQL Server Everywhere, Jacob Sebastian takes a more in-depth look at the smallest platform for SQL Server, Compact Edtion.
Operations Manager Custom Collection
An overview of how to collect data from TSQL into Operations Manager Performance Rules.
The Software Comparison - Part 4
The final installment of Steve Jones' comparison between software developers and other professions looks at the most closely related: engineers.
Introduction to Language Integrated Query (LINQ)
Language-Integrated Query (LINQ) is a groundbreaking innovation in Visual Studio 2008 and the .NET Framework version 3.5 that bridges the gap between the world of objects and the world of data. As LINQ is part of the development enhancements in SQL Server 2008, how can I have an understanding of how it works and how I can use it in other areas of administration, not just SQL Server?
SOX compliance checklist: IT security and SQL audits
Get security practices, procedures and documentation to meet Sarbanes-Oxley (SOX) compliance. This tip includes checklists to guide SQL DBAs and developers to inspect systems.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
BCA KCU RUNGKUT HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Raya Kendangsari Industri No.2, Kendangsari, Kec. Tenggilis Mejoyo, Surabaya, Jawa Timur...
BCA KCU KEDIRI HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Brawijaya No.8, Pocanan, Kec. Kota, Kota Kediri, Jawa Timur 64123
BCA KCU GALAXY HUBUNGI CS (0817-839-777)
WhatsApp: 0817839777, Jl. Dr. Ir. H. Soekarno No.37-39, Klampis Ngasem, Kec. Sukolilo, Surabaya, Jawa...
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers