Date: 12/19/10 (Web Development)    Keywords: php, html, xml, asp, web, microsoft

There is very little reference for this anywhere on the internet that I can find. MSDN has the properties listed with what data type the property is expected to be.

I'm hoping someone here may be able to help? My head has been scratched.

My three main points of reference are:

    #    Content Classes                http://msdn.microsoft.com/en-us/library/aa486257%28v=EXCHG.65%29.aspx
    #    Content Classes:Message        http://msdn.microsoft.com/en-us/library/aa123730%28v=EXCHG.65%29.aspx
    #    Properties by Namespace        http://msdn.microsoft.com/en-us/library/aa486269%28v=EXCHG.65%29.aspx

I have also looked at the MAPI references.

Outgoing mail XML

    xmlns:a=\"DAV:\"
    xmlns:b=\"urn:uuid:c2f41010-65b3-11d1-a29f-00aa00c14882/\"
    xmlns:c=\"xml:\"
    xmlns:d=\"urn:schemas:mailheader:\"
    xmlns:e=\"urn:schemas:httpmail:\"
    xmlns:f=\"http://schemas.microsoft.com/mapi/proptag/\"
    xmlns:g=\"http://schemas.microsoft.com/mapi/\"
    xmlns:h=\"http://schemas.microsoft.com/exchange/\"
    xmlns:i=\"urn:schemas-microsoft-com:office:office\"
    xmlns:j=\"urn:schemas:calendar:\"
    xmlns:k=\"http://schemas.microsoft.com/repl/\"
    xmlns:l=\"urn:schemas-microsoft-com:exch-data:\"
    >
   
       
            urn:content-classes:message
            http://localhost/exchange/
            attachment; filename=test.txt
            IPM.Note
            1
            2
            3
            ".$toEmail."
            ".$messageSubject."
            Test email
            test.txt
       
   


I cannot get the signature, nor the attachment to send. I have tried with/without content-base, content-disposition, attachmentfilename, signaturehtml, signaturetext and autoaddsignature in all combinations.

1. Is it possible to add signatures to outgoing messages through WebDAV with PHP? If so, how? I could] set the signatures up in my script, but I would like the user to be able to edit them via Outlook Web Access (OWA).

2. Is it possible to add attachment to outgoing messages through WebDAV with PHP? If so, how? A report will be generated before the mail functions are called. The report will be saved locally (e.g., http://localhost/report/2010-12-19.pdf) and not on the Exchange server (http://server.com/Exchange) -- I assume this is what content-base is for.

I know there are name spaces in the code that are unused. The emails send fine, but do not come with attachments or signatures.

Source: http://webdev.livejournal.com/571691.html

Date: 09/26/11 (PHP Community)    Keywords: php, database, sql, microsoft

I've got a Microsoft Access application that I'm going to have to convert to PHP and another database (PostGres or SQLite). The db portion I could do by hand if I needed to (the tables are not complicated). It's the forms that I'm worried about.

Does anyone have any experience with a tool for converting Access forms to PHP code? I found DB Convert, which looks promising, but I'd like to know about anyone's first-hand experiences.

Source: http://php.livejournal.com/682814.html

Date: 02/09/11 (C Sharp)    Keywords: asp, web, microsoft

Hi,

I have created a socket connection as described on MDSN web site:
client: http://msdn.microsoft.com/en-us/library/bew39x2a(v=VS.85).aspx
server: http://msdn.microsoft.com/en-us/library/fx6588te(v=VS.85).aspx

It works fine. Events here are:
1) Client sends request
2) Server receives it
3) Server sends response
4) Server shutdown the socket
5) Client receives response

Then, I know, that between 2) an 3) might be a time gap. I want to send few interim responses like:
2a) Server sends response: Still working on your request.
The problem here is that I cannot send a response without shutting down the socket, but as I shout it down I am not able to send neither 3) nor another 2a)

Is it possible for client to get response without closing the socket connection? Something like .flush()?


corresponding piece of code:

...
   public class MathTask {
      public string inputData;
      public int MaxTryCount;
      public int DelayBetweenNotificationsSec;
      public bool complete = false;
      public MathTask(string _data, int _maxTry, int _delayBetweenNotifications) {
         inputData = _data;
         MaxTryCount = _maxTry;
         DelayBetweenNotificationsSec = _delayBetweenNotifications;
         complete = false;
      }
   }
...
...
      private static void Send(Socket handler, MathTask taskData)
      {
         // Convert the string data to byte data using ASCII encoding.
         byte[] byteData = Encoding.ASCII.GetBytes(taskData.inputData);

         if (taskData.complete || (taskData.MaxTryCount <= 0))
         { // final sending
            // Begin sending the data to the remote device.
            IAsyncResult res = handler.BeginSend(byteData, 0, byteData.Length, 0,
                new AsyncCallback(SendCallback), handler);

         }
         else
         { // interim (notification) sending
            // Begin sending the data to the remote device.
            StateObject so = new StateObject();
            so.workSocket = handler;
            so.sb.Append(taskData.inputData);
            IAsyncResult res = handler.BeginSend(byteData, 0, byteData.Length, 0,
                new AsyncCallback(SendInterimCallback), so);
         }
      }

      // after sending notification (task is running)
      private static void SendInterimCallback(IAsyncResult ar)
      {
         try
         {
            // Retrieve the socket from the state object.
            StateObject so = (StateObject)ar.AsyncState;
            int bytesSent = so.workSocket.EndSend(ar);
            
            Console.WriteLine("Sent {0} bytes to client.", bytesSent);

            // client receives response ONLY AFTER this statement
            so.workSocket.Shutdown(SocketShutdown.Both);
            so.workSocket.Close();

         }
         catch (Exception e)
         {
            Console.WriteLine(e.ToString());
         }
      }
...

private static void ReceiveCallback( IAsyncResult ar ) {
        try {
            // Retrieve the state object and the client socket 
            // from the asynchronous state object.
            StateObject state = (StateObject) ar.AsyncState;
            Socket client = state.workSocket;

            // Read data from the remote device.
            int bytesRead = client.EndReceive(ar);

            if (bytesRead > 0) {
                // There might be more data, so store the data received so far.
            state.sb.Append(Encoding.ASCII.GetString(state.buffer,0,bytesRead));

                // Get the rest of the data.
                client.BeginReceive(state.buffer,0,StateObject.BufferSize,0,
                    new AsyncCallback(ReceiveCallback), state);
            } else {
                // All the data has arrived; put it in response.
                if (state.sb.Length > 1) {
                    response = state.sb.ToString();
                }
                // Signal that all bytes have been received.
                receiveDone.Set();
            }
        } catch (Exception e) {
            Console.WriteLine(e.ToString());
        }
    }

Source: http://csharp.livejournal.com/107817.html

Date: 09/16/09 (C Sharp)    Keywords: asp, microsoft

Why does my c# application stop after receiving a callback from unmanaged DLL?

I've just encountered this very strange problem. And wonder why it could happen.

The similar situation is described by someone on MSDN-site.
http://social.msdn.microsoft.com/Forums/en-US/clr/thread/25bd7c1d-373f-4ef7-a64b-a101897b6b9a/

But nobody there brought a clear explanation of that yet.

This little article described how to deal with callbacks from unmanaged code.
http://www.codeproject.com/KB/cs/win32_to_net.aspx
I think I did everything properly so that the program works well. But it doesn't.
If necessary, I could share snippets of my code.

Thank you.

Source: http://csharp.livejournal.com/105163.html

Date: 08/30/08 (Software)    Keywords: microsoft

Hello, I'm wondering where I could find Microsoft's Powerpoint (any version) for free to download?
And probably some installing instructions? Thanks, much.

Source: http://software.livejournal.com/80951.html

Date: 02/04/13 (SQL Server)    Keywords: asp, sql, microsoft

I'm thinking about doing this because our number of ad-hoc requests to run jobs has increased to an annoying level.  Does anyone out there have experience putting this into practice?

How to: Configure a User to Create and Manage SQL Server Agent Jobs
(SQL Server Management Studio)

Source: http://sqlserver.livejournal.com/77287.html

Date: 06/02/11 (SQL Server)    Keywords: database, asp, sql, security, microsoft

Passing this along for a friend...If you know anyone looking, please let me know.  Pay terms seem to be a little higher than normal for that many years of experience.  

Responsibilities:

• Installation, configuration, customization, maintenance and performance tuning of SQL Server 2005 & 2008 including SSIS, SSAS and SSRS.
• SQL version migration, patching and security management.
• Monitor database server capacity/performance and make infrastructure and architecture recommendations to management for necessary changes/updates.
• Perform database optimization, administration and maintenance (partitioning tables, partitioning indexes, indexing, normalization, synchronization, job monitoring, etc).
• Manage all aspects of database operations including implementation of database monitoring tools, event monitoring, diagnostic analysis, performance optimization routines and top-tier support for resolving support issues.
• Work with internal IT operations teams to troubleshoot network and server issues and optimize the database environment.
• Establish and enforce database change management standards including pushes from development to QA, on to production, etc;
• Proactively stay current with latest technologies and industry best practices associated to the position and responsibilities.
• Provide development and production support to troubleshoot day-to-day database or related application issues.
• Develop, implement and verify processes for system monitoring, storage management, backup and recovery.
• Develop, implement and verify database backup and disaster recovery strategies.
• Design and implement all database security to ensure integrity and consistency among the various database regions
• Develop and maintain documentation of the production environment.
• Manage SLAs and strict adherence to production controls - Sarbanes-Oxley (SOX) monitored via external audits

• Must have experience on SQL Server 2005.
• Good exposure on Installation, Configuration of database Clusters, Replication, Log shipping and Mirroring
• Expertise in Troubleshooting and performance monitoring SQL Server Database server (Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)
• Expertise in T-SQL and writing efficient and highly performing SQL Statements.
• Expertise in SQL Server Internals, wait events, profiler, windows events etc
• Must have understanding of key infrastructure technologies such as Clustering, SAN Storage, Virtualization, Cloud services etc.

• System administration fundamentals including Installation, Configuration & Security setups.
• Experience with SQL 2008 a plus.
• Experienced in architecting high availability, business resumption and disaster recovery solutions
• Microsoft SQL Server DBA Certification
• Experience with SCOM/SCCM/SCSM is a plus
• Extremely self motivated and ability to work within a globally dispersed team.

• Data Warehouse experience
• VLDB experience highly desired
• Experience with databases > 5 TB, processing 2 million + rows of data daily
• MS SQL Server 2005 Transact-SQL (T-SQL)
• Stored Procedure Development Communication Skills, work well with the team, and within team processes
• Database and file size and space forecasting ability
• Ability to manage a complex database system and assist the client with Database Integration for Future Business Intelligence efforts
• Confio Ignite Performance

• Bachelor's degree in Computer Science, Business Administration or other
• 10+ years experience as a Database Administrator 

Source: http://sqlserver.livejournal.com/75423.html

Date: 11/18/09 (SQL Server)    Keywords: asp, sql, security, web, microsoft

http://technet.microsoft.com/en-us/sqlserver/dd353197.aspx

Has anyone implemented security using the LOGON TRIGGER that came out with SQL Server 2005 SP2?

I'm just curious if anyone has setup this feature to protect their SQL Server from attack through their web servers.

Source: http://sqlserver.livejournal.com/71849.html

Date: 04/01/09 (Asp Dot Net)    Keywords: web, microsoft

Приглашаю в Study Group для подготовки к сертификации Microsoft.

Подробности про Study Group

Цель группы:
Подготовиться к сдаче программерских сертификатов Microsoft. Начнем со сдачи экзаменов по net (Web разработка).

Когда начнем работать?
Работать начнем через две недели. Задачи на эти 2 недели: составить программу курса, разработать план обучения и сдачи экзаменов. Так что присылайте ссылки на книги и др. информацию, которую хотите изучить мне (ведущему группы) скайп или в ЖЖ ivinsky.

Как часто планируется проводить встречи?
Основная задача группы: получение сертификатов Microsoft в кратчайшие сроки, поэтому встречи будут проводиться 5 дней в неделю по вечерам, время уточним позже. Если Вы хотите стать сертифицированным специалистам Microsoft в кратчайшие сроки, то это группа для Вас. Присоединяйтесь!

Source: http://aspdotnet.livejournal.com/103280.html

Date: 04/17/18 (Open Source)    Keywords: linux, microsoft

For the first time, Microsoft has released its own Linux kernel in a new Linux-based product: Azure Sphere.

Source: https://www.zdnet.com/article/microsoft-releases-its-first-linux-product/#ftag=RSSbaffb68

Date: 05/11/11 (Computer Help)    Keywords: browser, virus, web, microsoft, google

Hello, I've recently been dealing with computer trouble, and now that I'm past the worst of it, I've come to ask about something that's making me nutty: my display settings.


Problem in a nutshell: My programs (e.g. Internet Explorer, iTunes, Microsoft Word) don't seem to want to follow my designated screen resolution of 1024 by 768.

OS: Windows XP SP3


Web Browser: Internet Explorer 7 (I prefer it to the newer versions.)

Level of Experience: Probably easiest to say beginner


Problem: Because I unfortunately was victim of a rootkit a few weeks ago, my computer had to be wiped, and Windows was reinstalled. Since I got it back today, I've been building my computer to how it was before the virus, but my display settings are all off. I have a wide screen, and my default resolution before the virus was 1024 by 768 (I like it that way), so I restored it to that resolution. While I've taken pains to make my desktop look somewhat normal, my programs (e.g. Internet Explorer, iTunes) look rather larger and wider than they should in their screens. This is thoroughly annoying in Internet Explorer especially, since I don't like using full screen view (I don't use full screen for any programs). How do I get my programs (my desktop doesn't really seem to want to cooperate, either) to view normally?

Troubleshooting? -I messed with the space between my icons in the appearance section of the Display Properties, but this only affected the desktop. The toolbar at the bottom of my desktop still looks odd.
-I tried zooming in and out in Internet Explorer; didn't solve anything.
-I tried changing my dpi in the Display Properties, but to no avail.
-I've searched google several times but have found no help for this sort of problem.

Just for references, I'll include before and after screenshots from my display:


This is basically how my computer looked before it broke.


This is how my computer looks now: bloated toolbar and super wide IE page--the same facebook page takes up much more room.


This problem isn't dire, but it's MADDENING. If anyone has good ideas how to solve this, I would be extremely grateful. Thanks!

x-posting to computerhelp

Source: https://computer-help.livejournal.com/1024221.html

Date: 04/13/10 (IT Professionals)    Keywords: asp, sql, security, microsoft

I should know this.

Checking file system on C:
The type of the file system is NTFS.

A disk check has been scheduled.
Windows will now check the disk.
Cleaning up minor inconsistencies on the drive.
Cleaning up 57 unused index entries from index $SII of file 0x9.
Cleaning up 57 unused index entries from index $SDH of file 0x9.
Cleaning up 57 unused security descriptors.
CHKDSK is verifying Usn Journal...
Usn Journal verification completed.
CHKDSK is verifying file data (stage 4 of 5)...
Windows replaced bad clusters in file 87
of name \mssql\MSSQL$~1\Data\DISTRI~1.MDF.
Windows replaced bad clusters in file 7220
of name \mssql\MSSQL$~1\REPLDATA\unc\INSIGH~1\201004~1\TB5CD1~1.BCP.
Windows replaced bad clusters in file 26077
of name \mssql\MSSQL$~1\REPLDATA\unc\INSIGH~1\201004~1\TBLPDF~1.BCP.
Windows replaced bad clusters in file 32542
of name \mssql\MSSQL$~1\REPLDATA\unc\INSIGH~1\201003~1\TB5CD1~1.BCP.
Windows replaced bad clusters in file 34123
of name \mssql\MSSQL$~1\REPLDATA\unc\INSIGH~1\200802~1\TB50D9~1.BCP.
Windows replaced bad clusters in file 59114
of name \mssql\MSSQL$~1\REPLDATA\unc\INSIGH~1\200904~1\TB4CD1~1.BCP.
Windows replaced bad clusters in file 66747
of name \mssql\MSSQL$~1\REPLDATA\unc\INSIGH~1\200904~1\TBLPDF~1.BCP.
Windows replaced bad clusters in file 306249
of name \mssql\MSSQL$~1\REPLDATA\unc\INSIGH~1\200608~1\TB50D9~1.BCP.
Windows replaced bad clusters in file 313926
of name \mssql\MSSQL$~1\REPLDATA\unc\INSIGH~1\200608~2\TB50D9~1.BCP.
File data verification completed.
CHKDSK is verifying free space (stage 5 of 5)...
Free space verification is complete.
The size specified for the log file is too small.

213371743 KB total disk space.
137811912 KB in 82347 files.
42892 KB in 6088 indexes.
0 KB in bad sectors.
962587 KB in use by the system.
23040 KB occupied by the log file.
74554352 KB available on disk.

4096 bytes in each allocation unit.
53342935 total allocation units on disk.
18638588 allocation units available on disk.



Windows has finished checking your disk.
Please wait while your computer restarts.


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

~~~~

this is on my domain controller, this is a HP raid5 array consisting of 4 72gb scsi disks. how can you get bad clusters on a raided drive? how can I know which physical drive is failing?

did I actually lose any data/get any data corruption?

I have backups of course, the problem if its hardware failure, and I am going to do migration to windows 2008 r2 from windows 2003, it will still take sometime to initiate things, buying a single replacement scsi might be viable but if I can't identify the drive and have to get 4 scsi drives and rebuild the array 1 disk at the time, it would be problematic not to mention prone to disaster.

Source: https://itprofessionals.livejournal.com/90386.html

Date: 12/19/10 (Web Development)    Keywords: php, html, xml, asp, web, microsoft

There is very little reference for this anywhere on the internet that I can find. MSDN has the properties listed with what data type the property is expected to be.

I'm hoping someone here may be able to help? My head has been scratched.

My three main points of reference are:

    #    Content Classes                http://msdn.microsoft.com/en-us/library/aa486257%28v=EXCHG.65%29.aspx
    #    Content Classes:Message        http://msdn.microsoft.com/en-us/library/aa123730%28v=EXCHG.65%29.aspx
    #    Properties by Namespace        http://msdn.microsoft.com/en-us/library/aa486269%28v=EXCHG.65%29.aspx

I have also looked at the MAPI references.

Outgoing mail XML

    xmlns:a=\"DAV:\"
    xmlns:b=\"urn:uuid:c2f41010-65b3-11d1-a29f-00aa00c14882/\"
    xmlns:c=\"xml:\"
    xmlns:d=\"urn:schemas:mailheader:\"
    xmlns:e=\"urn:schemas:httpmail:\"
    xmlns:f=\"http://schemas.microsoft.com/mapi/proptag/\"
    xmlns:g=\"http://schemas.microsoft.com/mapi/\"
    xmlns:h=\"http://schemas.microsoft.com/exchange/\"
    xmlns:i=\"urn:schemas-microsoft-com:office:office\"
    xmlns:j=\"urn:schemas:calendar:\"
    xmlns:k=\"http://schemas.microsoft.com/repl/\"
    xmlns:l=\"urn:schemas-microsoft-com:exch-data:\"
    >
   
       
            urn:content-classes:message
            http://localhost/exchange/
            attachment; filename=test.txt
            IPM.Note
            1
            2
            3
            ".$toEmail."
            ".$messageSubject."
            Test email
            test.txt
       
   


I cannot get the signature, nor the attachment to send. I have tried with/without content-base, content-disposition, attachmentfilename, signaturehtml, signaturetext and autoaddsignature in all combinations.

1. Is it possible to add signatures to outgoing messages through WebDAV with PHP? If so, how? I could] set the signatures up in my script, but I would like the user to be able to edit them via Outlook Web Access (OWA).

2. Is it possible to add attachment to outgoing messages through WebDAV with PHP? If so, how? A report will be generated before the mail functions are called. The report will be saved locally (e.g., http://localhost/report/2010-12-19.pdf) and not on the Exchange server (http://server.com/Exchange) -- I assume this is what content-base is for.

I know there are name spaces in the code that are unused. The emails send fine, but do not come with attachments or signatures.

Source: https://webdev.livejournal.com/571691.html

Date: 09/26/11 (PHP Community)    Keywords: php, database, sql, microsoft

I've got a Microsoft Access application that I'm going to have to convert to PHP and another database (PostGres or SQLite). The db portion I could do by hand if I needed to (the tables are not complicated). It's the forms that I'm worried about.

Does anyone have any experience with a tool for converting Access forms to PHP code? I found DB Convert, which looks promising, but I'd like to know about anyone's first-hand experiences.

Source: https://php.livejournal.com/682814.html

Date: 02/09/11 (C Sharp)    Keywords: asp, web, microsoft

Hi,

I have created a socket connection as described on MDSN web site:
client: http://msdn.microsoft.com/en-us/library/bew39x2a(v=VS.85).aspx
server: http://msdn.microsoft.com/en-us/library/fx6588te(v=VS.85).aspx

It works fine. Events here are:
1) Client sends request
2) Server receives it
3) Server sends response
4) Server shutdown the socket
5) Client receives response

Then, I know, that between 2) an 3) might be a time gap. I want to send few interim responses like:
2a) Server sends response: Still working on your request.
The problem here is that I cannot send a response without shutting down the socket, but as I shout it down I am not able to send neither 3) nor another 2a)

Is it possible for client to get response without closing the socket connection? Something like .flush()?


corresponding piece of code:

...
   public class MathTask {
      public string inputData;
      public int MaxTryCount;
      public int DelayBetweenNotificationsSec;
      public bool complete = false;
      public MathTask(string _data, int _maxTry, int _delayBetweenNotifications) {
         inputData = _data;
         MaxTryCount = _maxTry;
         DelayBetweenNotificationsSec = _delayBetweenNotifications;
         complete = false;
      }
   }
...
...
      private static void Send(Socket handler, MathTask taskData)
      {
         // Convert the string data to byte data using ASCII encoding.
         byte[] byteData = Encoding.ASCII.GetBytes(taskData.inputData);

         if (taskData.complete || (taskData.MaxTryCount <= 0))
         { // final sending
            // Begin sending the data to the remote device.
            IAsyncResult res = handler.BeginSend(byteData, 0, byteData.Length, 0,
                new AsyncCallback(SendCallback), handler);

         }
         else
         { // interim (notification) sending
            // Begin sending the data to the remote device.
            StateObject so = new StateObject();
            so.workSocket = handler;
            so.sb.Append(taskData.inputData);
            IAsyncResult res = handler.BeginSend(byteData, 0, byteData.Length, 0,
                new AsyncCallback(SendInterimCallback), so);
         }
      }

      // after sending notification (task is running)
      private static void SendInterimCallback(IAsyncResult ar)
      {
         try
         {
            // Retrieve the socket from the state object.
            StateObject so = (StateObject)ar.AsyncState;
            int bytesSent = so.workSocket.EndSend(ar);
            
            Console.WriteLine("Sent {0} bytes to client.", bytesSent);

            // client receives response ONLY AFTER this statement
            so.workSocket.Shutdown(SocketShutdown.Both);
            so.workSocket.Close();

         }
         catch (Exception e)
         {
            Console.WriteLine(e.ToString());
         }
      }
...

private static void ReceiveCallback( IAsyncResult ar ) {
        try {
            // Retrieve the state object and the client socket 
            // from the asynchronous state object.
            StateObject state = (StateObject) ar.AsyncState;
            Socket client = state.workSocket;

            // Read data from the remote device.
            int bytesRead = client.EndReceive(ar);

            if (bytesRead > 0) {
                // There might be more data, so store the data received so far.
            state.sb.Append(Encoding.ASCII.GetString(state.buffer,0,bytesRead));

                // Get the rest of the data.
                client.BeginReceive(state.buffer,0,StateObject.BufferSize,0,
                    new AsyncCallback(ReceiveCallback), state);
            } else {
                // All the data has arrived; put it in response.
                if (state.sb.Length > 1) {
                    response = state.sb.ToString();
                }
                // Signal that all bytes have been received.
                receiveDone.Set();
            }
        } catch (Exception e) {
            Console.WriteLine(e.ToString());
        }
    }

Source: https://csharp.livejournal.com/107817.html

Date: 09/16/09 (C Sharp)    Keywords: asp, microsoft

Why does my c# application stop after receiving a callback from unmanaged DLL?

I've just encountered this very strange problem. And wonder why it could happen.

The similar situation is described by someone on MSDN-site.
http://social.msdn.microsoft.com/Forums/en-US/clr/thread/25bd7c1d-373f-4ef7-a64b-a101897b6b9a/

But nobody there brought a clear explanation of that yet.

This little article described how to deal with callbacks from unmanaged code.
http://www.codeproject.com/KB/cs/win32_to_net.aspx
I think I did everything properly so that the program works well. But it doesn't.
If necessary, I could share snippets of my code.

Thank you.

Source: https://csharp.livejournal.com/105163.html

Date: 08/30/08 (Software)    Keywords: microsoft

Hello, I'm wondering where I could find Microsoft's Powerpoint (any version) for free to download?
And probably some installing instructions? Thanks, much.

Source: https://software.livejournal.com/80951.html

Date: 02/04/13 (SQL Server)    Keywords: asp, sql, microsoft

I'm thinking about doing this because our number of ad-hoc requests to run jobs has increased to an annoying level.  Does anyone out there have experience putting this into practice?

How to: Configure a User to Create and Manage SQL Server Agent Jobs
(SQL Server Management Studio)

Source: https://sqlserver.livejournal.com/77287.html

Date: 06/02/11 (SQL Server)    Keywords: database, asp, sql, security, microsoft

Passing this along for a friend...If you know anyone looking, please let me know.  Pay terms seem to be a little higher than normal for that many years of experience.  

Responsibilities:

• Installation, configuration, customization, maintenance and performance tuning of SQL Server 2005 & 2008 including SSIS, SSAS and SSRS.
• SQL version migration, patching and security management.
• Monitor database server capacity/performance and make infrastructure and architecture recommendations to management for necessary changes/updates.
• Perform database optimization, administration and maintenance (partitioning tables, partitioning indexes, indexing, normalization, synchronization, job monitoring, etc).
• Manage all aspects of database operations including implementation of database monitoring tools, event monitoring, diagnostic analysis, performance optimization routines and top-tier support for resolving support issues.
• Work with internal IT operations teams to troubleshoot network and server issues and optimize the database environment.
• Establish and enforce database change management standards including pushes from development to QA, on to production, etc;
• Proactively stay current with latest technologies and industry best practices associated to the position and responsibilities.
• Provide development and production support to troubleshoot day-to-day database or related application issues.
• Develop, implement and verify processes for system monitoring, storage management, backup and recovery.
• Develop, implement and verify database backup and disaster recovery strategies.
• Design and implement all database security to ensure integrity and consistency among the various database regions
• Develop and maintain documentation of the production environment.
• Manage SLAs and strict adherence to production controls - Sarbanes-Oxley (SOX) monitored via external audits

• Must have experience on SQL Server 2005.
• Good exposure on Installation, Configuration of database Clusters, Replication, Log shipping and Mirroring
• Expertise in Troubleshooting and performance monitoring SQL Server Database server (Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)
• Expertise in T-SQL and writing efficient and highly performing SQL Statements.
• Expertise in SQL Server Internals, wait events, profiler, windows events etc
• Must have understanding of key infrastructure technologies such as Clustering, SAN Storage, Virtualization, Cloud services etc.

• System administration fundamentals including Installation, Configuration & Security setups.
• Experience with SQL 2008 a plus.
• Experienced in architecting high availability, business resumption and disaster recovery solutions
• Microsoft SQL Server DBA Certification
• Experience with SCOM/SCCM/SCSM is a plus
• Extremely self motivated and ability to work within a globally dispersed team.

• Data Warehouse experience
• VLDB experience highly desired
• Experience with databases > 5 TB, processing 2 million + rows of data daily
• MS SQL Server 2005 Transact-SQL (T-SQL)
• Stored Procedure Development Communication Skills, work well with the team, and within team processes
• Database and file size and space forecasting ability
• Ability to manage a complex database system and assist the client with Database Integration for Future Business Intelligence efforts
• Confio Ignite Performance

• Bachelor's degree in Computer Science, Business Administration or other
• 10+ years experience as a Database Administrator 

Source: https://sqlserver.livejournal.com/75423.html

Date: 11/18/09 (SQL Server)    Keywords: asp, sql, security, web, microsoft

http://technet.microsoft.com/en-us/sqlserver/dd353197.aspx

Has anyone implemented security using the LOGON TRIGGER that came out with SQL Server 2005 SP2?

I'm just curious if anyone has setup this feature to protect their SQL Server from attack through their web servers.

Source: https://sqlserver.livejournal.com/71849.html