|
|
-
|
|
A lot of our learning comes from different forums we visits on daily or weekly basis. This post is also inspired by one of the popular forum which I recently visited and found a very interesting question on Ms-Excel and SSIS. The reader had asked how he ca...
|
|
-
|
|
Recently I was trying to access my SSRS reports which are hosted in my system after a long vacation. The SQL Server and Reporting services both are installed on my machine. I tried to see one of the reports which I had developed for my personal use. SSRS w...
|
|
-
|
|
You might have seen this topic headline (Excel import issue) discussed in many forums, blogs etc. This issue puts a serious limitation to Ms-Excel to be used as a data source. In this post we are going to see conceptually; why the experts are saying so? I...
|
|
-
|
|
While I was browsing through the videos on Channel 9, I came across a nice video series explaining the fundamentals of C# development. If you are completely new to C# and want to start learning the language, this is one of the best video series which ex...
|
|
-
|
|
A while back i was creating a stored procedure to be used for pulling data from the SQL Server into cacti. The procedure was pulling data from a rather large table, which I had made sure was indexed properly for my query. When I executed the stored procedure from SQL Server Management Studio it ran ......
|
|
-
|
|
(The complete usable code is in the very bottom of this blog post)
Some of you may have seen this “numbers table” technique in use before, but I thought I would share a few simpel examples to those of you that haven’t seen the light yet
Lets start with a ...
|
|
-
|
|
If you are using SQL Server 2008 enterprise/datacenter edition, or SQL Server 2008 R2 standard or above, you are in the lucky possition to be able to compress your SQL Server backups. Often I see installations of these versions, where compression is not en...
|
|
-
|
|
In this article we will demonstrate how you can use a Pass-through query in Access with VBA code to create SQL Azure Logins. Microsoft Access can then use the Login and Password to gain access to SQL Azure Tables, Views, and Stored Procedures. We will create a Login using SQL in Access similar to th......
|
|
-
|
|
One of the best things about SQL Azure is how easy it is to manage User security. In this article we will show you how you can use Microsoft Access to add individual Users to Database Roles which makes managing User security much easier.
The Benefits of Using Flexible Database Roles
If you grant......
|
|
-
|
|
A couple of years ago, I heard some new terms: “10x developer” and “2x developer”.
A 10x developer seemed to complete tasks almost instantly. A 2x developer took a
long time to complete a task. These terms can also be applied to other jobs such
......
|
|