Day 24 Performance Monitor Sql Performance: ? performance counters sys.dm_os_performance_counters ? Top ten queries from sys.dm_exec_query_stats and sys.dm_exec_sql_text ? Processor: sys.dm_os_schedulers ?Memory : sys.dm_os_memory_clerks...
2011-04-24
878 reads
Day 22 SMO programming Part 3 In earlier blog we have discussed about server and database classes, using table clase...
2011-04-22
503 reads
Day 23 SMO programming Part 4 AS we can work with Server, Database, Table, Column. You can get the similar...
2011-04-22
362 reads
Day 21 SMO programming Part 2 Continue with my earlier blog where I discussed about the information about SMO. Today...
2011-04-21
487 reads
Day 20 Introduction to SMO >>SQL Server Management Objects (SMO) are objects designed for programmatic management of Microsoft SQL Server...
2011-04-20
414 reads
Day 19 Sql Server with .Net Using .Net programming is we can connect to sql server, its similar with any...
2011-04-19
540 reads
Day 18 PSSnapin Powershell works with cmdlets, and cmdlets are commands from snapins. Means spanin contains group of commands. so...
2011-04-18
808 reads
Day 17 Advance Mini Shell Mini shell is a good and can be used as a replacement of management studio,...
2011-04-17
411 reads
Day 16 Introduction to Mini Shell Mini Shell or SqlPS is the default shell utility provided by Microsoft to support...
2011-04-16
375 reads
Day 15 Introduction to Powershell for MS Sql Server So far we have discussed several features and information about Windows...
2011-04-15
780 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...